mcp-sql
by algonacci
mcp-sql is an MCP server that provides clients with the ability to access SQL databases, supporting both MySQL and PostgreSQL. It allows for remote SQL database interaction through the MCP framework.
Last updated: N/A
What is mcp-sql?
mcp-sql is an MCP server designed to enable client-side access to SQL databases (MySQL and PostgreSQL). It acts as a bridge, allowing clients to interact with databases remotely through the MCP framework.
How to use mcp-sql?
To use mcp-sql, you need to add the provided configuration snippet to your MCP config file. This configuration defines the 'sql_access' server, specifying the command to execute (uv), the directory where the server is located, and the Python script (main.py) to run.
Key features of mcp-sql
SQL database access
MySQL support
PostgreSQL support
MCP integration
Use cases of mcp-sql
Remote database querying
Data retrieval from SQL databases
Integrating SQL data with MCP applications
Centralized database access management
FAQ from mcp-sql
What databases are supported?
What databases are supported?
MySQL and PostgreSQL are currently supported.
How do I configure the server?
How do I configure the server?
Add the provided configuration snippet to your MCP config file.
What is the purpose of main.py?
What is the purpose of main.py?
main.py is the Python script that runs the MCP server logic.
Can I use other SQL databases?
Can I use other SQL databases?
Currently, only MySQL and PostgreSQL are supported. Future versions may include support for other databases.
Where should I place the mcp-sql directory?
Where should I place the mcp-sql directory?
The configuration example uses '%USERPROFILE%/Documents/GitHub/mcp-sql', but you can adjust the path to your actual directory location.