io.github.atarkowska/fastmcp-sqltools
A MCP server provides SQL database access with support for PostgreSQL, MySQL, and SQLite.
What can you do with io.github.atarkowska/fastmcp-sqltools?
- list_tables: List all tables in the database
- get_table_schema: Get detailed schema information for a table including columns, types, constraints, and indexes
- execute_query: Execute any SQL query (INSERT, UPDATE, DELETE, DDL, etc.)
- execute_safe_query: Execute read-only SELECT queries with additional safety checks
Install
Add this to your client's MCP configuration (Claude Desktop: claude_desktop_config.json; Cursor: .cursor/mcp.json; VS Code and others use the same "mcpServers" shape).
fastmcp-sqltoolsclaude mcp add fastmcp-sqltools -- uvx fastmcp-sqltools==0.3.0
{
"mcpServers": {
"fastmcp-sqltools": {
"command": "uvx",
"args": [
"fastmcp-sqltools==0.3.0"
]
}
}
}
Documentation
From the project's README on GitHub, refreshed weekly. Links open on GitHub.
FastMCP SQL Tools
mcp-name: io.github.atarkowska/fastmcp-sqltools
A Model Context Protocol (MCP) server built with FastMCP that provides SQL database access with support for PostgreSQL, MySQL, and SQLite.
Features
- list_tables: List all tables in the database
- get_table_schema: Get detailed schema information for a table including columns, types, constraints, and indexes
- execute_query: Execute any SQL query (INSERT, UPDATE, DELETE, DDL, etc.)
- execute_safe_query: Execute read-only SELECT queries with additional safety checks
Supported Databases
- PostgreSQL: Full support via asyncpg
- MySQL: Full support via aiomysql
- SQLite: Full support via aiosqlite
The server automatically detects the database type from the DATABASE_URL environment variable.
Configuration
Add the following to your claude_desktop_config.json:
{
"mcpServers": {
"sql-mcp-tools": {
"command": "uvx",
"args": [
"fastmcp-sqltools"
],
"env": {
"DATABASE_URL": "<your-database-url>"
}
}
}
}
Database URL Format
The DATABASE_URL should be in one of the following formats:
- PostgreSQL:
postgresql://user:password@host:port/databaseorpostgres://user:password@host:port/database - MySQL:
mysql://user:password@host:port/database - SQLite:
sqlite:///path/to/database.db(use three slashes for absolute path)
License
This project is licensed under the GNU Affero General Public License v3.0 (AGPL-3.0). See the LICENSE file for details.
Frequently asked questions
What is io.github.atarkowska/fastmcp-sqltools?
A MCP server provides SQL database access with support for PostgreSQL, MySQL, and SQLite.
How do I install io.github.atarkowska/fastmcp-sqltools?
It runs on your machine. In Claude Code: claude mcp add fastmcp-sqltools -- uvx fastmcp-sqltools==0.3.0. For other clients, paste the JSON configuration from this page into their MCP settings.
Does io.github.atarkowska/fastmcp-sqltools need an API key?
Its registry entry lists no required key or secret. Some features may still need an account with the service it connects to.
Is io.github.atarkowska/fastmcp-sqltools open source?
Yes. Its code is on GitHub under the AGPL-3.0 license.
Who maintains io.github.atarkowska/fastmcp-sqltools?
It is published by atarkowska. AI.tn lists it but does not maintain or endorse it.
From the official MCP Registry. Listing is not an endorsement: review a server's code and permissions before giving it access to your data.