mcp-alchemy
MCP Alchemy is a tool designed to connect Claude Desktop directly to various databases, enabling users to explore structures, write queries, and conduct analyses. It supports multiple database systems and enhances database interaction with smart query execution and data manipulation features.
MCP Alchemy
Status: Works great and is in daily use without any known bugs.
MCP Alchemy connects Claude Desktop directly to your databases, including PostgreSQL, MySQL, MariaDB, SQLite, Oracle, MS SQL Server, and CrateDB. It assists in database structure exploration, SQL query writing, relationship display, data analysis, and report creation. Requires uv installation and integration with Claude Desktop using database drivers. The tool allows extracting detailed table schemas, executing queries with smart result handling, and supports full dataset analysis through Claude Local Files.
Environment Variables
DB_URL: Required SQLAlchemy URLCLAUDE_LOCAL_FILES_PATH: Optional directory for full result setsEXECUTE_QUERY_MAX_CHARS: Optional output length (default 4000)
API Tools
- all_table_names: Lists all database tables
- filter_table_names: Finds tables by name substring
- schema_definitions: Provides detailed schemas
- execute_query: Executes queries with formatted outputs