SQL Server for MySQL, PostgreSQL, and SQLite

A server for making queries to MySQL, PostgreSQL, and SQLite databases.

SQL MCP Server for MySQL, PostgreSQL, and SQLite Databases

This is a powerfulMCP (Model Context Protocol) serverdesigned for seamless interaction with SQL databases, includingMySQL, PostgreSQL, and SQLite. It simplifieshow to connect to database MySQLand other SQL types, making it an ideal solution for developers looking for an efficientmcp mysql databaseintegration.

Whether you're building a new application or integrating with existing systems, this server provides the tools you need for managing your data.

Thismcp mysql tutorialwill guide you through its core functionalities.

- execute_sql_query- Execute SQL queries on a specified database. This tool is essential for running direct commands and is perfect for amcp mysql githubproject or any environment where direct SQL execution is needed.

- Parameters:

- dbType: Type of the database (mysql, postgresql or sqlite).
- connectionString: Connection string for the database (file path for sqlite).
- query: SQL query to execute.

- Parameters:

- dbType: Type of the database (mysql, postgresql or sqlite).
- connectionString: Connection string for the database (file path for sqlite).
- tableName: Name of the table to insert into.
- data: JSON object representing the data to insert (key-value pairs).

To use thismcp mysqlserver with your editor, you will generally need to configure it to recognize the server. The core principle involves providing the editor with the command to run the compiled server, typically located atbuild/index.js.

- MacOS:~/Library/Application Support/Claude/claude_desktop_config.json
- Windows:%APPDATA%/Claude/claude_desktop_config.json

{ "mcpServers": { "sql": { "command": "/path/to/sql/build/index.js" } } }

The exact configuration method may vary, but here are some common locations for configuration files:

- Roo Code:%APPDATA%\Code\User\globalStorage\rooveterinaryinc.roo-cline\settings\mcp_settings.json
- Cursor:%HOMEPATH%\.cursor(look for a relevant configuration file within this directory, e.g.,mcp_settings.jsonor similar). This setup allows seamlessmcp mysql cursorintegration.

Consult your editor's official documentation for detailed instructions on adding custom MCP servers.

Since MCP servers communicate over stdio, debugging can be challenging. We recommend using theMCP Inspector, which is available as a package script:

{ "mcpServers": { "sql": { "command": "/path/to/sql/build/index.js" } } }

Since MCP servers communicate over stdio, debugging can be challenging. We recommend using theMCP Inspector, which is available as a package script:

Maritime intelligence for tracking vessels, analysing ports, and exploring ship data.