Fastmcp Sqltools

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/database or postgres://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.