by DuckDB LabsVerified
Run analytical SQL queries against local files (CSV, Parquet, JSON) using DuckDB's high-performance OLAP engine directly from your AI assistant. DuckDB processes data locally without a server, making it ideal for ad-hoc analysis, data exploration, and ETL prototyping. The server supports querying files from local disk, S3, and HTTP URLs. Your AI can analyze datasets, generate reports, create aggregations, and explore data schemas — all with the speed of columnar processing and the familiarity of SQL.
npx mcp-server-duckdbAdd the following to your client configuration file.
{
"mcpServers": {
"mcp-server-duckdb": {
"command": "npx",
"args": [
"-y",
"@mcp/mcp-server-duckdb"
]
}
}
}{
"mcpServers": {
"mcp-server-duckdb": {
"command": "npx",
"args": [
"-y",
"@mcp/mcp-server-duckdb"
]
}
}
}{
"mcpServers": {
"mcp-server-duckdb": {
"command": "npx",
"args": [
"-y",
"@mcp/mcp-server-duckdb"
]
}
}
}| Client | Status |
|---|---|
| claude-desktop | Full Support |
| cursor | Full Support |
| claude-code | Full Support |
Run the install command above or copy the configuration snippet for your preferred MCP client.
Add any required API keys or authentication tokens to your MCP client configuration. Check the GitHub README for setup details.
Once configured, the server's tools become available in your AI assistant. You can access features like sql queries on local files (csv, parquet, json) and s3 and http file access.
DuckDB Analytics MCP Server is an MCP (Model Context Protocol) server created by DuckDB Labs that allows AI coding assistants to interact with external services and data sources programmatically. Run analytical SQL queries against local files (CSV, Parquet, JSON) using DuckDB's high-performance OLAP engine directly from your AI assistant. DuckDB processes data locally without a server, making it ideal for ad-hoc analysis, data exploration, and ETL prototyping. The server supports querying files from local disk, S3, and HTTP URLs. Your AI can analyze datasets, generate reports, create aggregations, and explore data schemas — all with the speed of columnar processing and the familiarity of SQL. The server communicates via the stdio transport type and is licensed under MIT.
MCP servers like DuckDB Analytics MCP Server extend the capabilities of AI assistants beyond code generation and into real-world integrations. Instead of manually switching between your AI assistant and external tools, the MCP protocol lets the assistant call structured APIs directly — reading data, triggering actions, and maintaining context across interactions. This reduces context switching and allows developers to stay in their IDE or terminal while the assistant handles the integration layer.
With 7 documented capabilities — including sql queries on local files (csv, parquet, json), s3 and http file access, schema exploration and inference — DuckDB Analytics MCP Server is one of the more feature-rich MCP servers in its category. Its 3.5K GitHub stars indicate strong community adoption and interest.
Use DuckDB Analytics MCP Server when you want your AI coding assistant to interact with run analytical sql queries against local files (csv, parquet, json) using duckdb directly from the chat or terminal interface, without manual copy-pasting.
If you find yourself constantly switching between your AI assistant and external tools,DuckDB Analytics MCP Server eliminates that friction. The assistant can read context, take actions, and report results — all within a single conversation thread.
MCP servers work well for semi-automated workflows where the AI handles repetitive integration tasks — fetching data, updating records, posting notifications — while you focus on higher-level decisions and code architecture.
DuckDB Analytics MCP Server works across 3 compatible clients, including claude-desktop, cursor, claude-code. This means you can use the same server configuration regardless of which AI coding tool your team prefers.
Several MCP servers offer overlapping functionality. The right choice depends on your specific integration needs, the AI clients you use, and your preference for community vs. official support. Here is how DuckDB Analytics MCP Server compares:
Sentry MCP Server by Sentry is less popular by GitHub stars (1.2K vs 3.5K). Both servers are maintained by different teams — evaluate documentation quality and recent commit activity when choosing.
Elasticsearch MCP Server by Elastic Community is less popular by GitHub stars (520 vs 3.5K). Both servers are maintained by different teams — evaluate documentation quality and recent commit activity when choosing.
Datadog MCP Server by Datadog Community is less popular by GitHub stars (480 vs 3.5K). Both servers are maintained by different teams — evaluate documentation quality and recent commit activity when choosing.
PagerDuty MCP Server by PagerDuty Community is less popular by GitHub stars (320 vs 3.5K). Both servers are maintained by different teams — evaluate documentation quality and recent commit activity when choosing.
DuckDB Analytics MCP Server allows AI coding assistants like Claude Code, Cursor, and VS Code Copilot torun analytical sql queries against local files (csv, parquet, json) using duckdb's high-performance olap engine directly from your ai assistant. duckdb processes data locally without a server, making it ideal for ad-hoc analysis, data exploration, and etl prototyping. the server supports querying files from local disk, s3, and http urls. your ai can analyze datasets, generate reports, create aggregations, and explore data schemas — all with the speed of columnar processing and the familiarity of sql through the Model Context Protocol. Instead of manually performing these actions yourself, the AI assistant invokes server tools directly during your conversation.
Run `npx mcp-server-duckdb` in your terminal, or copy one of the JSON configuration snippets above into your MCP client settings file. Most clients (Claude Desktop, VS Code, Cursor) use a JSON config file — see the Configuration section for client-specific snippets.
Yes, DuckDB Analytics MCP Server is free and open source under the MIT license. You can use it, modify it, and contribute to it via the GitHub repository. Note that while the server itself is free, the external services it connects to (such as APIs or cloud platforms) may have their own usage costs.
DuckDB Analytics MCP Server has been tested with claude-desktop, cursor, claude-code (full support). Any MCP-compatible client should work, but verify specific tool support in the client's documentation. The compatibility table above shows the latest status.
Share your experience with DuckDB Analytics MCP Server and help other developers.