Home - News ( United States | United Kingdom | Italy | Germany ) - Football scores

Showing content from https://github.com/schemacrawler/SchemaCrawler-MCP-Server-Usage below:

schemacrawler/SchemaCrawler-MCP-Server-Usage: Find out how to use SchemaCrawler MCP Server

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.

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

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

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.

Try other MCP Clients too.

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

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

RetroSearch is an open source project built by @garambo | Open a GitHub Issue

Search and Browse the WWW like it's 1997 | Search results from DuckDuckGo

HTML: 3.2 | Encoding: UTF-8 | Version: 0.7.4