Query database schemas and generate valid SQL for any RDBMS
MCP server that exposes SchemaCrawler database schema discovery tools for exploring, searching, and documenting database structures.
Why it matters
Connect to relational databases to retrieve schema metadata, generate syntactically valid SQL queries, and answer questions about database structure including column naming conventions and table relationships.
Outcomes
What it gets done
Connect to any relational database management system
Retrieve and explore database schema metadata and structure
Generate valid SQL queries for connected databases
Answer questions about column prefixes and naming conventions
Install
Add it to your toolbox
Run in your project directory:
curl -fsSL https://spark.entire.vc/get/vb-schemacrawler | bash Overview
SchemaCrawler MCP Server
SchemaCrawler MCP Server exposes database schema discovery and comprehension capabilities. SchemaCrawler can search database schema objects using regular expressions and output schema and data in readable text formats. The server runs as a Docker container and provides data governance features. Use this when you need to explore and document database schemas, search for specific database objects using pattern matching, or support data governance workflows. It fits scenarios where you want to explore database structures through Visual Studio Code.
What it does
SchemaCrawler MCP Server connects to SchemaCrawler, a free database schema discovery and comprehension tool. SchemaCrawler can search database schema objects using regular expressions and output schema and data in readable text formats, supporting data governance workflows. The server runs as a Docker container.
When to use - and when NOT to
Use this MCP server when you need to explore database schemas, search for specific database objects using pattern matching, or generate human-readable documentation of database structures. It fits data governance scenarios where you need to understand and document existing database architectures.
Do NOT use this if you need direct database modification capabilities or real-time query execution - SchemaCrawler focuses on schema discovery and comprehension, not data manipulation.
Inputs and outputs
You provide database connection details through an MCP client. SchemaCrawler can search for database schema objects using regular expressions and output the schema and data in readable text format.
Integrations
The server is available as an official Docker-verified image from the Docker MCP Catalog:
docker pull mcp/schemacrawler-ai
Early release versions are published at schemacrawler/schemacrawler-ai on Docker Hub. The server integrates with Visual Studio Code - you configure it following the Use MCP servers in VS Code documentation.
Prerequisites include Docker, Docker Compose, and Visual Studio Code. This is a bare project that acts as an MCP client for the SchemaCrawler AI MCP Server for use in "Agent" mode.
Who it's for
Database administrators and data engineers who need to document and understand complex database schemas. Teams who want to search across database objects using regular expressions and generate schema documentation. Developers working in Visual Studio Code who want to explore database structures.
Source README
:star: Star it :arrow_heading_up: if you love it!
SchemaCrawler AI MCP Server: Usage
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 AI MCP Server for use in "Agent" mode. You can find documentation on how to use the server here.
The SchemaCrawler AI MCP Server is available as an official Docker-verified image from the Docker MCP Catalog at mcp/schemacrawler-ai. Early release versions are published at schemacrawler/schemacrawler-ai.
Prerequisites
- Install supporting software
- Docker
- Docker Compose
- Visual Studio Code
- Read Use MCP servers in VS Code
- Clone this project, and open it in Visual Studio Code
Getting Started
Refer to the getting started documentation, and more documentation in docs/.
FAQ
Common questions
Discussion
Questions & comments · 0
Sign In Sign in to leave a comment.