Schemacrawler Mcp Client Usage
What is Schemacrawler Mcp Client Usage
SchemaCrawler-MCP-Client-Usage is a project that allows users to utilize Visual Studio Code as a client for the SchemaCrawler MCP Server. It enables users to interact with database schemas in an efficient manner.
Use cases
Use cases include querying available tables in a database, exploring relationships between database objects, and generating documentation for database schemas.
How to use
To use SchemaCrawler-MCP-Client-Usage, first ensure that you have Docker, Docker Compose, and Visual Studio Code installed. Clone the project and open it in Visual Studio Code. Start the SchemaCrawler MCP Server using the command ‘docker-compose -f schemacrawler-mcpserver.yaml up -d’. Then, connect to the MCP Server in Visual Studio Code and ask questions about your database in ‘Agent’ mode.
Key features
Key features include the ability to search for database schema objects using regular expressions, outputting schema and data in a readable format, and the integration with Visual Studio Code for enhanced user interaction.
Where to use
SchemaCrawler-MCP-Client-Usage can be used in various fields such as database management, data governance, and software development where understanding and managing database schemas is crucial.
Clients Supporting MCP
The following are the main client software that supports the Model Context Protocol. Click the link to visit the official website for more information.
Overview
What is Schemacrawler Mcp Client Usage
SchemaCrawler-MCP-Client-Usage is a project that allows users to utilize Visual Studio Code as a client for the SchemaCrawler MCP Server. It enables users to interact with database schemas in an efficient manner.
Use cases
Use cases include querying available tables in a database, exploring relationships between database objects, and generating documentation for database schemas.
How to use
To use SchemaCrawler-MCP-Client-Usage, first ensure that you have Docker, Docker Compose, and Visual Studio Code installed. Clone the project and open it in Visual Studio Code. Start the SchemaCrawler MCP Server using the command ‘docker-compose -f schemacrawler-mcpserver.yaml up -d’. Then, connect to the MCP Server in Visual Studio Code and ask questions about your database in ‘Agent’ mode.
Key features
Key features include the ability to search for database schema objects using regular expressions, outputting schema and data in a readable format, and the integration with Visual Studio Code for enhanced user interaction.
Where to use
SchemaCrawler-MCP-Client-Usage can be used in various fields such as database management, data governance, and software development where understanding and managing database schemas is crucial.
Clients Supporting MCP
The following are the main client software that supports the Model Context Protocol. Click the link to visit the official website for more information.
Content
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
- Supporting software
- Docker
- Docker Compose
- Visual Studio Code
- Clone this projects, and open it in Visual Studio Code
Start the SchemaCrawler MCP Server
- Pull the latest image for SchemaCrawler MCP Server
docker pull schemacrawler/schemacrawler:extra-early-access-release - Run the SchemaCrawler MCP Server
docker compose -f schemacrawler-mcpserver.yaml up -d - Check server health in a browser http://localhost:8080/health
Use Visual Studio Code MCP Client
- Read Use MCP servers in VS Code
- Connect to the MCP Server in Visual Studio Code (the server is configured in the “.vscode/mcp.json” file)
- 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”
Connect to Your Database
- Stop the SchemaCrawler MCP Server
docker compose -f schemacrawler-mcpserver.yaml down -t0 - Edit the “schemacrawler-mcpserver.yaml” file to add your database connection details
- Restart the SchemaCrawler MCP Server
Dev Tools Supporting MCP
The following are the main code editors that support the Model Context Protocol. Click the link to visit the official website for more information.
