MCP Alchemy

- Four built-in tools: all_table_names, filter_table_names, schema_definitions, execute_query
- Supports 10+ SQLAlchemy-compatible databases
- Connection pooling optimized for long-running MCP servers
- Integration with claude-local-files for large dataset analysis
- Smart truncation and clean vertical output for query results

Ensure you have uv installed:

curl -LsSf https://astral.sh/uv/install.sh | sh

Add to your claude_desktop_config.json. You need to add the appropriate database driver in the `--with parameter.

- DB_URL: SQLAlchemy database URL (required)
- CLAUDE_LOCAL_FILES_PATH: Directory for full result sets (optional)
- EXECUTE_QUERY_MAX_CHARS: Maximum output length (optional, default 4000)
- DB_ENGINE_OPTIONS`: JSON string containing additional SQLAlchemy engine options (optional)

- all_table_names
- Return all table names in the database
- No input required
- Returns comma-separated list of tables

  users, orders, products, categories

  

- filter_table_names
- Find tables matching a substring
- Input: q (string)
- Returns matching table names

  Input: "user"

  Returns: "users, user_roles, user_permissions"

  

- schema_definitions
- Get detailed schema for specified tables
- Input: table_names (string[])
- Returns table definitions including:
- Column names and types
- Primary keys
- Foreign key relationships
- Nullable flags

  users:

      id: INTEGER, primary key, autoincrement

      email: VARCHAR(255), nullable

      created_at: DATETIME

      

      Relationships:

        id -> orders.user_id

  

- execute_query
- Execute SQL query with vertical output format
- Inputs:
- query (string): SQL query
- params (object, optional): Query parameters
- Returns results in clean vertical format:

  1. row

  id: 123

  name: John Doe

  created_at: 2024-03-15T14:30:00

  email: NULL

Result: 1 rows