DuckDB MCP server

This is a small helper that connects your AI assistant to a DuckDB database on your own computer. DuckDB is a database that lives in a single file, handy for looking at data locally. It is useful for anyone who has a data file and wants to ask questions about it in plain English.

What this MCP server does

You ask your AI a question about your data, like how many rows a table has. Your AI turns that into a SQL query and sends it to this helper. The helper runs the query against your DuckDB file and sends the result back. Your AI then explains the result to you in the chat. It can also create tables or insert data if you allow it.

Click to zoom

What you can do with it

• Ask questions about the data in your DuckDB file
• List tables and inspect their columns
• Run SQL queries and see the results
• Create new tables and add rows
• Join tables together to answer a question
• Keep the database safe by running it in read-only mode

Try asking your AI

• “What tables are in my DuckDB database?”
• “Show me the first 10 rows of the sales table.”
• “How many orders were placed last month?”
• “Create a table called customers with a name and an email column.”

What it gives back to you

You get answers in the chat, usually as a short table of rows or a single number. For queries that change data, you get a short message saying it worked. Your AI often adds a sentence or two explaining what the result means.

Before you start

Who it's for

Anyone who has data in a DuckDB file and wants to explore it by asking questions instead of writing SQL.