Imagine having an AI assistant that actually understands your database schema and helps you make sense of your tables and columns, helps you craft perfect SQL queries that actually work, and saves you from hours of documentation diving. The SchemaCrawler MCP Server is here, and it it free and open source.
Forget complex installations and configuration headaches. The SchemaCrawler MCP Server runs in a Docker container, meaning you can get up and running with just a few commands, using your favorite MCP Client in "Agent" mode.
What Can It Do For You?
🔍 Explore Your Database Structure
- View all tables and views at a glance
- Examine column details including data types and constraints
- Understand relationships between tables with foreign key information
🛠️ Improve Your Database Design
- Find design issues with the built-in schema linting
- Discover missing indexes that could improve performance
- Identify nullable columns in unique constraints
📝 Simplify SQL Development
- Understand table schemas before writing queries
- See sample data to better understand the information you're working with
- Generate proper SQL based on your database structure
Getting Started in 4 Easy Steps
Clone https://github.com/schemacrawler/SchemaCrawler-MCP-Client-Usage
Start the Server
docker-compose -f schemacrawler-mcpserver.yaml up -d
Verify It's Running
Check server health at http://localhost:8080/healthConnect in VS Code
The server is already configured in.vscode/mcp.json- just open VS Code and start asking questions!
Connect to Your Own Database
Want to use this with your own database? No problem!
- Stop the current server
docker-compose -f schemacrawler-mcpserver.yaml down -t0
Edit the connection details
Updateschemacrawler-mcpserver.yamlwith your database connection informationRestart the server
docker-compose -f schemacrawler-mcpserver.yaml up -d
Start Exploring Today!
Simply ask questions about your database in VS Code's chat panel:
- "What tables are available in my database?"
- "Show me the columns in the Books table"
- "What foreign keys reference the Authors table?"
- "Are there any design issues with my database schema?"
- "Write SQL to find books and their authors"
Powered by SchemaCrawler - Free database schema discovery and comprehension tool
Top comments (2)
This looks like a huge time saver for devs who hate digging through endless schema docs. Any plans to add support for more advanced query optimization or explain plans?
I'll give it a deeper try, but yet, it deserves some tweet