Claude MarketplacesSubmit
runekaagaard avatar

MCP Alchemy Server

runekaagaard/mcp-alchemy

MCP Alchemy integrates Claude Desktop directly with multiple database systems including PostgreSQL, MySQL, SQLite, Oracle, MS SQL Server, and other SQLAlchemy-compatible databases, enabling Claude to explore database structures, write and validate SQL queries, visualize table relationships, and analyze datasets. The server provides tools for database exploration, SQL query assistance, relationship mapping, and large dataset analysis with artifact generation capabilities. By connecting Claude to databases as an expert assistant, MCP Alchemy solves the problem of requiring manual database interaction and SQL expertise for data exploration and reporting tasks.

GitHub stars
403
tools
4
last updated
Mar 9, 2026
View on GitHub

Tools

4 tools

Public tool metadata for what this MCP can expose to an agent.

all_table_namesReturn all table names in the database

Return all table names in the database

No parameter schema in public metadata yet.

filter_table_namesFind tables matching a substring

Find tables matching a substring

No parameter schema in public metadata yet.

schema_definitionsGet detailed schema for specified tables

Get detailed schema for specified tables

No parameter schema in public metadata yet.

execute_queryExecute SQL query with vertical output format

Execute SQL query with vertical output format

No parameter schema in public metadata yet.

Sponsors

Promote your product hereReach 125k+ visitors monthlyPromote your product hereReach 125k+ visitors monthlyAgent CaffeineSponsoredClose your lid, come back to finished workSnugSponsoredThe clipboard manager for the AI eraPromote your product hereReach 125k+ visitors monthlyWaxSponsoredBlock anything with supervision, without erasing your iPhonePromote your product hereReach 125k+ visitors monthlyknobsSponsoredSee your site on any phone, any day, in any language

Readme

MCP Alchemy

PulseMCP Badge

Status: Actively maintained and in daily use. Tested releases are published to PyPI with git tags, and issues and pull requests are triaged regularly.

Let Claude be your database expert! MCP Alchemy connects Claude Desktop directly to your databases, allowing it to:

  • Help you explore and understand your database structure
  • Assist in writing and validating SQL queries
  • Displays relationships between tables
  • Analyze large datasets and create reports
  • Claude Desktop Can analyse and create artifacts for very large datasets using claude-local-files.

Works with PostgreSQL, MySQL, MariaDB, SQLite, Oracle, MS SQL Server, CrateDB, Vertica, and a host of other SQLAlchemy-compatible databases.

MCP Alchemy in action

Installation

View the full README on GitHub

Details

Repository
github.com/runekaagaard/mcp-alchemy
Categories
Databases, AI & LLM Tools, Documents & Knowledge

Related Databases MCP servers

View all
1faucetdb avatarFaucetfaucetdb/faucetSQL database to MCP tools and REST API: PostgreSQL, MySQL, SQL Server, Oracle, SQLite, Snowflake.170stars
2hypequery avatarhypequery ClickHousehypequery/hypequeryGoverned ClickHouse analytics for agents: named datasets and metrics as tools, never raw SQL.104stars
3enessari avatarMetabase Ai Assistantenessari/metabase-ai-assistantMCP Server for Metabase - 111 tools for SQL generation, dashboards & PostgreSQL43stars
4verygoodplugins avatarMCP Local WPverygoodplugins/mcp-local-wpWordPress database access via Local by Flywheel. Execute read-only MySQL queries and inspect schema.34stars
5haymon-ai avatarDbmcphaymon-ai/dbmcpDatabase MCP server for MySQL, MariaDB, PostgreSQL & SQLite with PII redaction and write-prevention0stars
6nicholasglazer avatarGnosis MCPnicholasglazer/gnosis-mcpZero-config MCP server for searchable documentation. SQLite or PostgreSQL.31stars