Fastmcp Sqltools

🚀 FastMCP SQL Tools

A Model Context Protocol (MCP) server built with FastMCP, offering SQL database access for PostgreSQL, MySQL, and SQLite.

🚀 Quick Start

FastMCP SQL Tools is a Model Context Protocol (MCP) server. It's constructed with FastMCP and enables access to SQL databases, supporting PostgreSQL, MySQL, and SQLite.

✨ Features

• list_tables: List all tables in the database.
• get_table_schema: Retrieve 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.

📦 Installation

No specific installation steps are provided in the original document.

💻 Usage Examples

No code examples are provided in the original document.

📚 Documentation

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 follow 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 an absolute path).

🔧 Technical Details

No technical details are provided in the original document.

📄 License

This project is licensed under the GNU Affero General Public License v3.0 (AGPL - 3.0). See the LICENSE file for details.