Check the installed DuckDB version to determine available features and ensure compatibility with your SQL queries.
MIT
521,667 tools. Updated 2026-09-06 11:42
"DuckDB" matching MCP tools:
- Check whether a specified table exists in a DuckDB database to prevent errors before running queries.MIT
- Run SQL queries directly on DuckDB databases to retrieve, manipulate, and analyze data.MIT
- Execute SQL queries against MotherDuck or DuckDB databases directly from your AI assistant or IDE. Analyze data with DuckDB SQL dialect efficiently.MIT
- Shows all tables in a DuckDB database, optionally including views, to reveal the complete schema.MIT
- Get the schema and column details of a table in DuckDB to understand its structure before querying.MIT
Matching MCP Servers
- AlicenseAqualityBmaintenanceEnables read-only SQL querying and exploration of data files (CSV, Parquet, JSON, Excel, etc.) via DuckDB, supporting local paths, globs, URLs, and S3 buckets.5MIT
- AlicenseAqualityAmaintenanceA minimal MCP server that provides a persistent DuckDB SQL engine to AI assistants, enabling natural-language querying of CSVs, Parquet, and cloud data with 12 tools and optional read-only mode.12MIT
- Execute SQL queries on DuckDB databases to retrieve, analyze, or modify data stored locally, in memory, or in the cloud.MIT
- Execute SQL queries on DuckDB databases to retrieve, filter, and manipulate data. Directly interact with the database for analysis and exploration.MIT
- Inspect an SQL query in DuckDB to retrieve its execution plan and performance insights for optimization.MIT
- Run declarative PySpark transformations on DuckDB datasets for heavy aggregations, using a fixed set of validated operations like filter, select, groupBy, and orderBy.MIT
- List all configured database connections to discover available options and select one for use. Returns connection names, types, and details without exposing passwords.Apache 2.0
- Execute SQL queries against a database connection, including SELECT, INSERT, UPDATE, DELETE, with parameterized inputs to prevent SQL injection.Apache 2.0
- Execute parameterized read-only SQL queries against cataloged fitness-data views to retrieve paginated results for a chosen athlete, with safeguards that reject mutations, filesystem access, and system tables.AGPL 3.0
- Join two spatial datasets using intersects, within, or contains predicates, with automatic engine selection and warnings for empty or non-overlapping results.AGPL 3.0
- Execute SQL queries against Rapid7 vulnerability, asset, policy, and remediation data to filter, aggregate, and join tables for targeted security analysis.MIT
- Execute SQL SELECT queries on a Bauplan data catalog table and save results to a CSV file, providing the output file path.MIT
- Verify the OmniData server is running, can reach DuckDB, and reports guardrail configuration (row limits, timeout, DB path). Use first to confirm the MCP connection is alive.MIT
- Generate summary statistics for each column in a dataset: data type, null percentage, distinct count, min/max, and numeric quartiles. Uses DuckDB to profile large tables efficiently.MIT
- Download completed Rapid7 vulnerability, policy, or remediation exports and load them into the local database for querying.MIT
- Query geospatial data using DuckDB spatial SQL, returning preview rows or materializing full results as GeoParquet with provenance.AGPL 3.0Destructive
- Execute data quality validation rules from a YAML file against DuckDB, BigQuery, Athena, Databricks, or Postgres, returning a JSON report with optional LLM-driven root cause analysis.Apache 2.0