SchemaCrawler - MCP Server Usage

[!NOTE]

• Please see the SchemaCrawler website for more details.
• Explore the SchemaCrawler command-line with a live online tutorial.

About

SchemaCrawler is a free database schema discovery and comprehension tool. SchemaCrawler has a good mix of useful features for data governance. You can search for database schema objects using regular expressions, and output the schema and data in a readable text format.

This is a bare project that acts as an MCP client for the SchemaCrawler MCP Server for use in "Agent" mode.

Prerequisites

1. Supporting software
   • Docker
   • Docker Compose
   • Visual Studio Code
2. Clone this projects, and open it in Visual Studio Code

Start the SchemaCrawler MCP Server

1. Pull the latest image for SchemaCrawler MCP Server

   docker pull schemacrawler/schemacrawler-ai:latest
   

2. Run the SchemaCrawler MCP Server

   docker compose -f schemacrawler-mcpserver.yaml up -d
   

3. Check server health in a browser http://localhost:9292/health

Use Visual Studio Code MCP Client

1. Read Use MCP servers in VS Code
2. Connect to the MCP Server in Visual Studio Code (the server is configured in the ".vscode/mcp.json" file)
3. Ask questions about your database in "Agent" mode - here are some examples:
   • "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"
4. Additional "Agent" modes are provided in this project too. Use the "database-expert" or "sql-query-assistant" modes for fine-tuned help for specific tasks.

Use Other MCP Clients

Try other MCP Clients too.

• Microsoft AI Shell for a shell
• ... and more at Awesome MCP Clients

Connect to Your Database

1. Stop the SchemaCrawler MCP Server

   docker compose -f schemacrawler-mcpserver.yaml down -t0
   

2. Edit the "schemacrawler-mcpserver.yaml" file to add your database connection details
3. Restart the SchemaCrawler MCP Server