DuckDB MCP server: ask questions, get governed answers

DuckDB AI analytics: what you can ask

Typical questions from analysts and data teams. Each answer shows the definition, source and query behind it.

• What was net revenue by region last quarter, using our approved revenue definition?
• Which product lines had the largest margin change month over month?
• Show monthly order counts for the past 12 months.
• Who are our top 20 customers by total spend this year?
• Which orders have a missing ship date or negative quantity?
• Compare average order value by channel this quarter versus last.

How Nexatron connects to DuckDB

Whose permissions

Questions run through the connection's DuckDB account, so its grants are the outer limit. Inside that, Nexatron roles and the row policies your administrator defines decide what each person can see.

Read and write

Read-only. Nexatron reads DuckDB data to answer questions and never writes to DuckDB.

Setup

Runs inside Nexatron's embedded engine, with no external credentials. Steps: choose the source → enter connection details → verify → ask. No data migration and no pipeline to build: data is queried where it lives.

DuckDB MCP connector for Claude, ChatGPT and Copilot

Nexatron's hosted MCP server is a governed DuckDB MCP connector: Claude, ChatGPT and Microsoft Copilot ask questions of your DuckDB data through it. Each person signs in as themselves, so the assistant sees only what they may see.

Connect DuckDB to Claude, ChatGPT or Copilot

1. Connect DuckDB to your Nexatron workspace.
2. In Claude, add Nexatron from Claude's connector directory. In ChatGPT or Copilot, add a custom MCP connector with the server URL https://api.nexatron.io/api/v1/mcp.
3. Sign in with your own Nexatron identity (OAuth 2.1), then ask your DuckDB questions.

DuckDB connector FAQ

Can I ask DuckDB questions without writing queries?

Yes. The connector is available now. Ask in Teams, Slack, the Nexatron web app, or an AI assistant connected through Nexatron's MCP server.

Does Nexatron respect DuckDB permissions?

Yes. The DuckDB account's grants are the outer limit, and your row policies narrow it for each person.

Can Nexatron change data in DuckDB?

No. Nexatron only reads DuckDB data.

What do I need to connect DuckDB?

Nothing external: it runs inside Nexatron.

Is there a DuckDB MCP server for Claude, ChatGPT or Copilot?

Yes: Nexatron's hosted MCP server, once DuckDB is connected to your workspace. It is Nexatron's server, not one published by DuckDB, and the assistant gets the same governed answer as the Nexatron app.