MCP Alchemy

@runekaagaard

Basic information

About MCP Alchemy

A MCP (model context protocol) server that gives the LLM access to and knowledge about relational databases like SQLite, Postgresql, MySQL & MariaDB, Oracle, and MS-SQL.

MCP Alchemy config

No standard config provided

This server doesn't expose a parseable MCP config block in its README. See the repository for install instructions.

Repository

MCP Alchemy tools

Return all table names in the database

Find tables matching a substring

Get detailed schema for specified tables

Execute SQL query with vertical output format

Overview

What is MCP Alchemy?

MCP Alchemy connects Claude Desktop directly to your databases via SQLAlchemy, allowing it to explore database structure, write and validate SQL queries, display table relationships, and analyze large datasets. It works with PostgreSQL, MySQL, MariaDB, SQLite, Oracle, MS SQL Server, CrateDB, Vertica, and other SQLAlchemy-compatible databases. It is designed for users who want Claude to act as a database expert.

How to use MCP Alchemy?

Install uv, then add a configuration entry to claude_desktop_config.json with the command uvx, the mcp-alchemy package, and the required database driver in the --with parameter. Set the DB_URL environment variable to your database’s SQLAlchemy URL. For SQLite, no extra driver is needed; for others, include the appropriate driver (e.g., psycopg2-binary for PostgreSQL). Optionally set CLAUDE_LOCAL_FILES_PATH to enable full result set access.

Key features of 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

Use cases of MCP Alchemy

Explore and understand database structure without manual SQL
Assist Claude in writing and validating SQL queries interactively
Analyze large datasets and generate reports via claude-local-files
Create Claude artifacts from database results for further visualization

Frequently asked questions

What databases are supported?

PostgreSQL, MySQL, MariaDB, SQLite, Oracle, MS SQL Server, CrateDB, Vertica, and any other SQLAlchemy-compatible database.

What dependencies are required?

You need `uv` installed. The server runs via `uvx` and includes `mcp-alchemy`. For most databases, an additional driver package must be added with the `--with` parameter (e.g., `pymysql` for MySQL).

How does connection pooling work?

The default uses `pool_pre_ping=True`, `pool_size=1`, `max_overflow=2`, `pool_recycle=3600`, and `isolation_level='AUTOCOMMIT'`. These can be overridden via the `DB_ENGINE_OPTIONS` environment variable.

Where does data live?

Data remains in your own database. MCP Alchemy only reads and writes through the provided `DB_URL` connection. No data is sent to external servers.

What transport or authentication does it use?

The server communicates with Claude Desktop over stdio (standard input/output). Authentication is handled entirely by the database credentials in `DB_URL`.

Comments

More Databases MCP servers

Neon MCP Server

neondatabase

MCP server for interacting with Neon Management API and databases

617

PostgreSQL

modelcontextprotocol

Model Context Protocol Servers

88.1K

Database Gateway

centralmind

Universal MCP-Server for your Databases optimized for LLMs and AI-Agents.

531

MCP Server for MySQL based on NodeJS

benborla

A Model Context Protocol server that provides read-only access to MySQL databases. This server enables LLMs to inspect database schemas and execute read-only queries.

1.9K

Multi Database MCP Server

FreePeak

A powerful multi-database server implementing the Model Context Protocol (MCP) to provide AI assistants with structured access to databases.

397