SQL Query MCP server

This is a small helper that lets your AI assistant look inside a database and answer questions about the data, without ever changing it. It works with PostgreSQL, MySQL, and Hive. It is handy if you often need numbers or lists from a database but don't want to write SQL yourself.

What this MCP server does

You ask your AI something like "how many customers signed up last month". The AI uses this helper to see which tables exist and what columns they have. Then it runs a read-only query, meaning it can only look, not change anything. The helper checks the query is safe first, runs it, and hands the result back. Your AI then explains the answer in plain words in the chat.

Click to zoom

What you can do with it

• List the databases and tables your AI can see
• Describe a table's columns, keys, and indexes
• Run short read-only queries and get results back
• Start long queries in the background and fetch results later
• Check how a query would run with a query plan
• Grab a small sample of rows from a table
• Export query results to a CSV or Excel file on your machine
• Import a prepared CSV or Excel file into an existing table

Try asking your AI

• “What tables are in the crm database?”
• “Show me the columns of the orders table.”
• “How many orders were placed last week?”
• “Give me a sample of 10 rows from the customers table.”
• “Explain how this query would run: SELECT * FROM orders WHERE status = 'paid'”

What it gives back to you

You get answers in the chat: lists of tables, column names, small samples of rows, counts, and short summaries. For longer queries, your AI can show the results page by page. If you ask for an export, it writes a CSV or Excel file on the machine where the helper runs, and tells you where it saved it.

Before you start

Who it's for

Anyone who needs quick answers from a PostgreSQL, MySQL, or Hive database but doesn't want to write SQL, like analysts, support staff, and operations people.