MCP Alchemy

Example Use Cases

• 1

  Discover and inspect all table names and schema details (columns, types, PKs, FKs, nullable flags) in a SQL database.

• 2

  Write, validate, and execute SQL queries with readable vertical output and smart truncation for large results.

• 3

  Analyze or export large query results and generate reports or visualizations via integration with claude-local-files.

Description

MCP Alchemy integrates Claude Desktop with SQLAlchemy-compatible databases (PostgreSQL, MySQL, SQLite, Oracle, MS SQL Server, etc.) to expose table names, detailed schema definitions, relationships, and to execute SQL queries with clean, vertical results. It helps users explore database structure, write and validate SQL, and analyze or export large result sets (optionally via claude-local-files). The tool is designed for easy local deployment and supports common DB drivers while providing smart truncation and ISO-formatted outputs for clarity.