SchemaCrawler MCP server

This is a helper that connects your AI assistant to a relational database, the kind of database that stores information in tables with rows and columns. It lets the AI look at how your database is built so it can help you write SQL and answer questions about your data. It is handy for anyone who works with a database but does not have the table layout memorized.

What this MCP server does

You ask your AI a question about your database, like what a certain column name means or how to write a query. The AI sends that request to this helper program. The helper talks to your database and reads its structure, the tables, columns, and how they relate. It sends that information back to the AI. The AI then gives you a clear answer or a piece of SQL that actually matches your database.

Click to zoom

What you can do with it

• Ask what a table or column is for
• Get SQL that matches your real table and column names
• Find out how tables are connected to each other
• Check what columns exist in a table before writing a query
• Understand confusing column prefixes or naming
• Explore an unfamiliar database you just got access to

Try asking your AI

• “What does the column prefix cust_ mean in this database?”
• “Write me a SQL query that lists all orders from last month.”
• “Which tables are related to the customers table?”
• “What columns does the invoices table have?”

What it gives back to you

You get answers in plain chat, like an explanation of what a column means or a list of tables and columns. When you ask for SQL, it gives you a query written with your real table and column names, ready to copy. It can also describe how tables connect to each other. Everything comes back as text in the conversation, not as files.

Before you start

Who it's for

Anyone who works with a database and wants help writing SQL or understanding its structure, including analysts, support staff, and developers who are new to a database.