Connect to DuckDB via MCP for queries, table creation, and schema inspection.
This tool is აღწcribed as enabling DuckDB interaction via MCP, including SQL queries, table creation, and schema inspection. No credentials or remote endpoints are declared, so overall risk is relatively low, but it still warrants caution because it can execute queries and access local database data.
The materials explicitly state that no keys or environment variables are required. No API tokens, account credentials, or external service authentication are indicated, so credential exposure appears limited.
No remote endpoint is declared, and the description only mentions local DuckDB interaction. There is no factual indication that user data is sent to external services.
The system flags executes-code, and the tool functionality includes running SQL queries and creating tables. This is a normal capability for a database/local tool and merits caution, but the materials do not show requests for system privileges beyond the stated purpose.
The tool declares support for SQL queries, table creation, and schema inspection, and mentions an optional read-only mode. This means it can read and potentially modify DuckDB database contents. The access scope is consistent with its purpose, but data modification risk exists if read-only mode is not enabled.
There is a public open-source repository under the MIT license, which is a positive factor that lowers risk. However, the source is a third-party registry, community adoption is 0 stars, and maintenance status is unknown, so confidence in ongoing review and maintenance is limited; evaluation in an isolated environment is advisable.
Copy the install command and let the AI configure it · recommended for beginners
No copy-paste install info for "mcp-server-duckdb" yet — see the docs or source repo.
Connect to the DuckDB database and query the orders table for the last 30 days. Return total orders, revenue, and average order value, grouped by week.
A reusable SQL result summary with weekly aggregated business metrics.
Create a DuckDB table named campaign_performance with fields for date, channel, clicks, conversions, and spend, and provide the CREATE TABLE SQL.
A CREATE TABLE statement with a clearly defined schema and field types.
Inspect the current DuckDB database and list all tables with their columns and types. Highlight which tables are suitable for sales analysis.
A schema overview that helps users quickly understand available tables and their use cases.
Let AI safely query and manage DuckDB databases through MCP tools.
Query and manage multiple databases with read-only access and schema inspection.
Query and analyze local or cloud data with DuckDB through AI assistants.
Connect to major databases via MCP to run SQL queries and commands.
Interact with SQLite via MCP for CRUD, SQL queries, and schema exploration.
Connect to PostgreSQL and MySQL, run SQL, and manage database transactions.