Cursor

Cursor is an AI-powered code editor that supports Windows, macOS, and Linux.

This topic describes how to integrate Cursor with seekdb Agent Skill to get AI-invokable knowledge packs and workflows, and how to integrate Cursor with seekdb MCP Server to build backend applications quickly.

seekdb Agent Skill with Cursor

Agent Skills is an AI capability extension format led by Anthropic and released as an open standard. The idea is to package instructions, scripts, and resources into a folder that AI agents can discover and load as "skills" to complete tasks more accurately and efficiently.

seekdb Agent Skills are knowledge packs and workflows that AI can invoke automatically, built on that standard. After you install them in Cursor, when you ask seekdb-related questions, Cursor’s AI will use the skill instructions to look up seekdb docs or run data import/export and similar operations—no need to memorize commands or copy from docs. For more about Agent Skills, see seekdb Agent Skills.

Supported skills

Skill	Description	Example questions
seekdb (default)	Covers official seekdb docs (getting started, development guides, SDK/API, multi-modal data, integration and operations). The AI finds the right doc for your question and answers with examples.	How do I deploy seekdb? / How does vector search work in seekdb?
importing-to-seekdb	Import data into seekdb collections and optionally vectorize specified columns. You can preview Excel/CSV structure and sample data before importing.	Import sample_products.xlsx into seekdb and vectorize the Details column.
querying-from-seekdb	Filter by metadata for scalar search; full-text + semantic hybrid search with RRF ranking; export results to CSV or Excel.	Recommend 2 phones with rating ≥ 4.3 and AMOLED display.

Install seekdb Agent Skills in Cursor

Cursor loads Agent Skills from the .cursor/skills directory in your project root. Install as follows:

1. Go to the project root where you want to install the skills.

   cd /path/to/your/project

2. Install the installer package.

   pip install seekdb-agent-skills

3. Run the interactive installer.

   seekdb-agent-skills

4. Select the tool.

   Use ↑/↓ to choose Cursor, then Enter to confirm.

   🚀 seekdb Agent Skills Installer
   ==================================================
   
   📋 Select tool to install to:
   ? Select one tool (use ↑↓ to navigate, Enter to confirm, Ctrl+C to cancel): (Use arrow keys)
     Claude Code
     OpenClaw
   » Cursor
     Codex
     OpenCode
     GitHub Copilot
     Qoder
     Trae

5. Confirm the install location.

   📁 Project root: /path/to/your/project
   (Skills will be installed under .cursor/skills)
   ? Install skills to this directory? (Y/n)

   Enter Y to continue or n to exit.

6. Select skills to install.

   If you only need the AI to reference seekdb docs, press Enter to accept the default. To import/export Excel or CSV from seekdb, also select importing-to-seekdb and querying-from-seekdb. Use ↑/↓ to move, Space to toggle multiple, Enter to confirm.

   📦 Select skills to install:
   ? Select skills (use ↑↓ to navigate, Space to select, Enter to confirm, Ctrl+C to cancel): (Select multiple with Space)
   » ● seekdb
     ○ importing-to-seekdb
     ○ querying-from-seekdb

Use seekdb Agent Skills in Cursor

After installation, open the project root (where skills are installed) in Cursor and ask questions in chat or in the editor. The AI will call the right skill and answer using the docs or skill capabilities.

Example prompts:

• How do I deploy seekdb on Mac?
• How does vector search work in seekdb?
• How do I do hybrid search in seekdb?

seekdb MCP Server with Cursor

MCP (Model Context Protocol) is an open-source protocol launched by Anthropic in November 2024. It enables large language models to interact with external tools or data sources. With MCP, the model can instruct tools to perform actions directly instead of users copying and executing the model’s output.

seekdb MCP Server uses MCP to let models interact with seekdb and run SQL. It is open-source on GitHub and works with a suitable client to build project prototypes quickly.

Prerequisites

• You have deployed seekdb.

• Install Python 3.11 or later and the corresponding pip. If the Python version on your machine is too low, you can use Miniconda to create a new Python 3.11 or later environment. For more information, see Miniconda installation guide.

• Install the Python package manager uv. After the installation is complete, run the uv --version command to verify whether the installation is successful:

  pip install uv
  uv --version

• Download Cursor and install the version that matches your operating system. When you use Cursor for the first time, you need to register a new account or log in with an existing account. After you log in, you can create a new project or open an existing project.

Step 1: Obtain the database connection information

Contact the deployment personnel or administrator of seekdb to obtain the corresponding database connection string, for example:

mysql -h$host -P$port -u$user_name -p$password -D$database_name

Parameter description:

• $host: the IP address for connecting to seekdb.

• $port: the port for connecting to seekdb. The default value is 2881.

• $database_name: the name of the database to be accessed.

  tip

  The user for the connection must have the CREATE, INSERT, DROP, and SELECT privileges on the database.

• $user_name: the database connection account.

• $password: the account password.

Step 2: Configure the seekdb MCP Server

Install the seekdb MCP Server

Run the following command to install the seekdb MCP Server:

pip install seekdb-mcp-server

Configure the seekdb server environment variables in the .env file

Create a file named .env in the current directory and add the following content:

vi .env

SEEKDB_HOST=localhost      # Database host
SEEKDB_PORT=2881           # Database port (default: 2881)
SEEKDB_USER=your_username
SEEKDB_PASSWORD=your_password
SEEKDB_DATABASE=your_database

Start the seekdb MCP Server in SSE mode

env $(cat .env | xargs) uvx seekdb-mcp-server --transport sse --port 8000 --host 0.0.0.0

Create a working directory for the Cursor client and configure the seekdb MCP Server

Manually create a working directory for Cursor and open it with Cursor. The files generated by Cursor will be stored in this directory. An example directory name is cursor.

Use the shortcut Ctrl + L (Windows) or Command + L (MacOS) to open the chat dialog box. Click the gear icon in the upper right corner and select MCP Tools.

Add and configure MCP Servers

1. Click Add Custom MCP to fill in the configuration file.

   

2. Fill in the configuration file and click Confirm.

   {
   "mcpServers": {
       "sse-seekdb": {
       "autoApprove": [],
       "disabled": false,
       "timeout": 60,
       "type": "sse",
       "url": "http://ip:port/sse"
       }
   }
   }

3. If the configuration is successful, the status will show as Available.

   

Test the MCP Server

In the dialog box, enter the prompt: How many tables in the test database?. The Cursor client will display the SQL statement to be executed. After confirming, click the Run tool button to execute. The Cursor client will display all the table names in the test database, indicating that we have successfully connected to seekdb.

Use FastAPI to quickly create a RESTful API project

You can use FastAPI to quickly create a RESTful API project. FastAPI is a Python web framework that allows you to build RESTful APIs quickly.

1. Create a customer table

   In the dialog box, enter the prompt: Create a "customer" table with "ID" as the primary key and containing fields such as "name", "age", "telephone", and "location". After confirming the SQL statement, click the Run tool button to execute.

   

2. Insert test data

   In the dialog box, enter the prompt: Insert 10 pieces of data into the customer table. After confirming the SQL statement, click the Run tool button to execute. If the insertion is successful, you will see the message: Done! Here are the 10 customer records inserted:.

   

3. Create a FastAPI project

   In the dialog box, enter the prompt: Create a FastAPI project on the customer table. Click the Run tool button to execute.

   

   This step will automatically generate multiple files. It is recommended to select All accept for the first use, as the AI-generated file content may be uncertain. You can adjust them as needed later.

4. Configure the database connection information for the FastAPI project

   Configure the seekdb connection information in the .env file.

   

5. Install project dependencies

   Run the following command to install the project dependencies:

   pip install -r requirements.txt

6. Start the FastAPI project

   Run the following command to start the FastAPI project:

   source .env
   uvicorn main:app --reload

7. View the data in the table

   Run the following command in the command line, or use other request tools to view the data in the table:

   curl http://127.0.0.1:8000/customers

   The returned result is as follows:

   [{"name":"John Smith","age":32,"telephone":"555-0101","location":"New York, NY","ID":1},{"name":"Emily Johnson","age":28,"telephone":"555-0102","location":"Los Angeles, CA","ID":2},{"name":"Michael Chen","age":45,"telephone":"555-0103","location":"San Francisco, CA","ID":3},{"name":"Sarah Williams","age":36,"telephone":"555-0104","location":"Chicago, IL","ID":4},{"name":"David Brown","age":29,"telephone":"555-0105","location":"Houston, TX","ID":5},{"name":"Jessica Lee","age":41,"telephone":"555-0106","location":"Phoenix, AZ","ID":6},{"name":"Robert Garcia","age":55,"telephone":"555-0107","location":"Philadelphia, PA","ID":7},{"name":"Amanda Martinez","age":23,"telephone":"555-0108","location":"San Antonio, TX","ID":8},{"name":"Christopher Wilson","age":38,"telephone":"555-0109","location":"San Diego, CA","ID":9},{"name":"Nicole Taylor","age":31,"telephone":"555-0110","location":"Dallas, TX","ID":10}]