CoreMCP database server

CoreMCP is a small helper program that connects your AI assistant to a real database, such as Microsoft SQL Server or PostgreSQL. It is made for people who need answers from company data but do not want to write SQL by hand. It is handy if your database sits on a company server or an older system that is hard to reach.

What this MCP server does

You ask your AI a question in normal words, like which customers ordered most last month. The AI turns that into a database query and sends it to CoreMCP. CoreMCP checks the query is safe, runs it against your database, and limits how many rows come back. It also hides things like emails and card numbers if you turn that on. Then it hands the results back to your AI, which explains them to you in the chat.

Click to zoom

What you can do with it

• Ask questions about your data in plain English and get answers
• List the tables in a database and see what columns they have
• Look up the full details of one table, including keys and comments
• See all views and stored procedures in the database
• Run saved queries you set up in advance, like daily sales
• Keep results small with an automatic row limit
• Hide private details like emails and card numbers before you see them

Try asking your AI

• “Which ten customers placed the most orders last month?”
• “Show me the columns and data types in the orders table.”
• “List all stored procedures in the erp_db database.”
• “Run the get_daily_sales tool for 2024-05-01.”

What it gives back to you

You get answers in the chat, usually as a short table or a list of rows. Your AI often adds a plain sentence explaining what the numbers mean. If you asked about the structure of the database, you get a list of tables, columns, or procedures. Nothing is changed in your database unless you deliberately turn on write access.

Before you start

Who it's for

Office workers, analysts, and support teams who need quick answers from company databases without writing SQL themselves.