XiYan MCP server

This is a small helper that lets your AI talk to a database for you. Instead of writing database queries yourself, you just ask a question in normal words and it goes and fetches the answer. It is handy for anyone who has data in MySQL or PostgreSQL but does not want to learn query language.

What this MCP server does

You type a question in everyday words, like how many orders came in last month. Your AI passes that question to this helper. The helper turns your words into a proper database query using a built-in model, then runs it against your MySQL or PostgreSQL database. The results come back and your AI shows them to you in the chat. It can also list the tables in your database so you know what is there.

Click to zoom

What you can do with it

• Ask for numbers and totals from your database in plain words
• List the tables available in your database
• Look at sample rows from a specific table
• Get answers about customers, orders, or any data you have stored
• Query MySQL or PostgreSQL without writing any query language

Try asking your AI

• “How many customers signed up last month?”
• “Show me the top 5 products by total sales.”
• “List all tables in my database.”
• “What is the average order value for this year?”

What it gives back to you

You get back the actual data from your database, shown as a list, a table, or a short summary in the chat. If you asked for a count, you get a number. If you asked for rows, you get those rows. It does not change anything in your database, it only reads.

Before you start

Who it's for

Anyone who has data in MySQL or PostgreSQL and wants quick answers without learning database query language, such as analysts, small business owners, or office workers who deal with reports.