What databases are supported?
PostgreSQL, MySQL, MariaDB, SQLite, Oracle, MS SQL Server, CrateDB, Vertica, and any other SQLAlchemy-compatible database.
@runekaagaard
Basic information
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.
No standard config provided
This server doesn't expose a parseable MCP config block in its README. See the repository for install instructions.
RepositoryReturn all table names in the database
Find tables matching a substring
Get detailed schema for specified tables
Execute SQL query with vertical output format
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.
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.
all_table_names, filter_table_names, schema_definitions, execute_queryPostgreSQL, MySQL, MariaDB, SQLite, Oracle, MS SQL Server, CrateDB, Vertica, and any other SQLAlchemy-compatible database.
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).
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.
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.
The server communicates with Claude Desktop over stdio (standard input/output). Authentication is handled entirely by the database credentials in `DB_URL`.

Archived reference MCP server for read-only PostgreSQL access: inspect schemas and run SQL inside read-only transactions.

Connect Karma.Domains to ChatGPT, Claude, Cursor, VS Code, or another MCP client — and find a domain in plain language. The same auctions, expired, backorder, and buy-now data you use in the app, plus saved filters, note
Zero-dependency, token-efficient database MCP server for Postgres, MySQL, SQL Server, MariaDB, SQLite.

Healthcare provider data for AI assistants, from the official CMS NPPES dataset (updated weekly). Look up any NPI (active or deactivated), search providers and organizations by name, city, state, ZIP, taxonomy code or pl
Comments