Skip to main content
Glama
fastmcp-sqltools

fastmcp-sqltools

by atarkowska

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

Related MCP server: mcp-sqlite3

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.

Available Tools

4 tools
execute_queryB

Execute a SQL query and return results. WARNING: This can execute any SQL including DDL and DML statements.

Inputs: query (required), params. Returns: result

execute_safe_queryA

Execute a read-only SQL query (SELECT only). This is safer than execute_query as it prevents data modification.

Inputs: query (required), params. Returns: result

get_table_schemaB

Get the schema (column definitions) for a specific table.

Inputs: table_name (required), schema. Returns: result

list_tablesB

List all tables in the specified schema.

Inputs: schema. Returns: result

Tool Schema Changelog

Recent tool additions, removals, and schema changes observed during successful MCP inspections.

Loading tool schema changelog…

    TDQS

    A3.7/5.0

    Scored across 4 tools

    Disambiguation5/5

    Each tool has a clearly distinct purpose: execute_query for any SQL, execute_safe_query for read-only, get_table_schema for column definitions, and list_tables for table listing. No ambiguity.

    Naming Consistency5/5

    All tool names follow a consistent verb_noun pattern in snake_case, e.g., execute_query, list_tables. No deviations.

    Tool Count5/5

    Four tools is appropriate for a SQL tool server covering query execution, safe querying, schema retrieval, and table listing. Well-scoped.

    Completeness3/5

    Core operations are present, but missing a tool to list schemas (list_tables requires a schema parameter), which could cause agent failures. DDL is covered via execute_query.

    Related MCP Connectors

    Related MCP Servers

    • A
      license
      Not graded
      quality
      B
      maintenance
      Provides safe, configurable SQL database access via MCP tools, enabling schema introspection, predefined queries, and structured updates with multi-backend support.
      2
      MIT
    • A
      license
      Not graded
      quality
      D
      maintenance
      Exposes sqlite3 database functionality as MCP tools, enabling SQL query execution, schema management, and CRUD operations.
      48 PyPI
      1
      MIT
    • A
      license
      Not graded
      quality
      D
      maintenance
      Provides comprehensive SQLite database interaction through MCP, enabling CRUD operations, custom SQL queries, and database exploration.
      660 npm
      130
      MIT
    • A
      license
      Not graded
      quality
      D
      maintenance
      Enables database interaction (MySQL, PostgreSQL, SQL Server) via MCP, supporting SQL queries and command execution.
      29 npm
      MIT