MySQL MCP

• CRUD

• SQL

• MCP Cursor

• Node.js 18.0.0

• MySQL

1. - `.env.example` `.env` - `.env` MySQL

Cursor

1. Cursor MCP

• 1: "MCP"

• 2: MCP

• 3: `/connect-mcp http://localhost:3001/sse`

1. MySQL

2. ``` mysql://tables ```

3. ``` mysql://schema/ ```

4. ``` mysql://data/ ```

5. ``` create-table tableName=" " schema="id INT PRIMARY KEY AUTO_INCREMENT, name VARCHAR(255)" ```

6. ``` drop-table tableName=" " ```

7. ``` insert-data tableName=" " data="{\"name\": \" \", \"age\": 30}" ```

8. ``` update-data tableName=" " data="{\"name\": \" \"}" condition="{\"id\": 1}" ```

9. ``` delete-data tableName=" " condition="{\"id\": 1}" ```

10. ``` query-data tableName=" " fields="[\"id\",\"name\"]" condition="{\"age\": 30}" ```

11. SQL ``` execute-sql sql="SELECT * FROM users WHERE age > 18" params="[]" ```

12. ``` create-table-guide tableName=" " ```

13. ``` insert-data-guide tableName=" " ```

14. ``` database-operations ```

15. ``` create-table tableName="users" schema="id INT PRIMARY KEY AUTO_INCREMENT, name VARCHAR(255) NOT NULL, email VARCHAR(255) UNIQUE, age INT" ```

16. ``` insert-data tableName="users" data="{\"name\": \" \", \"email\": \"zhangsan@example.com\", \"age\": 30}" ```

17. ``` mysql://data/users ```

• MySQL