JUHE API Marketplace
schemacrawler avatar
MCP Server

SchemaCrawler-MCP-Server-Usage

Connect to any relational database, and be able to get valid SQL, and ask questions like what does a certain column prefix mean.

4
GitHub Stars
8/18/2025
Last Updated
No Configuration
Please check the documentation below.

README Documentation

SchemaCrawler - MCP Server Usage

[!NOTE]

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.

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

Quick Actions

Key Features

Model Context Protocol
Secure Communication
Real-time Updates
Open Source