Execute SQL queries on DuckDB databases to retrieve, analyze, or modify data stored locally, in memory, or in the cloud.
MIT
194,485 tools. Last updated 2026-06-11 22:32
"DuckDB" matching MCP tools:
- 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
- Lists all configured database connections with details like type and host. Use this to discover available connections before using other tools.Apache 2.0
- Execute SQL queries (SELECT, INSERT, UPDATE, DELETE) against a database connection. Supports parameterized queries to prevent SQL injection.Apache 2.0
- Execute SQL SELECT queries on a Bauplan data catalog table and save results to a CSV file, providing the output file path.MIT
- Create polar line plots from SQL queries on CSV or Parquet data sources. Visualize radial and angular coordinates with optional color coding for multi-dimensional analysis.MIT
Matching MCP Servers
- Alicense-qualityDmaintenanceA Model Context Protocol (MCP) server implementation for DuckDB, providing database interaction capabilities through MCP tools. It would be interesting to have LLM analyze it. DuckDB is suitable for local analysis.Last updated176MIT
- AlicenseBqualityCmaintenanceEnables AI assistants and IDEs to execute SQL queries on local DuckDB databases, in-memory databases, or cloud-stored databases with support for flexible connections and configurable result limits.Last updated11MIT
- Create box plots from SQL query results on CSV or Parquet data sources to visualize statistical distributions and identify outliers in your data.MIT
- Visualize data distribution patterns by creating a 2D histogram from SQL query results. Generate density heatmaps for CSV and Parquet data sources to analyze spatial relationships and concentration areas.MIT
- Create bar charts from SQL query results on CSV, Parquet, or database sources to visualize data relationships and trends for analysis.MIT
- Execute SQL queries on CSV and Parquet data sources using DuckDB syntax to retrieve structured results for data analysis and visualization.MIT
- Create polar scatter plots by querying data sources with SQL. Visualize radial and angular coordinates from query results as scatter points on a polar coordinate system.MIT
- Create histogram visualizations from SQL query results on CSV, Parquet, or database sources. Generate distribution plots for data analysis and business intelligence.MIT
- Create strip plots from SQL queries on CSV or Parquet data sources to visualize relationships between variables with optional color coding for additional dimensions.MIT
- Create scatter plots from SQL query results on CSV or Parquet data sources to visualize relationships between variables for data analysis.MIT
- Visualize SQL query results as line charts from CSV, Parquet, or database sources to analyze trends and patterns in data.MIT
- Run read-only SQL queries on cached open data resources, including CSV, TSV, XLSX, JSON, and ODS files. Supports SELECT statements with row limits for safe analysis.MIT
- Retrieve column names, inferred data types, and sample values from a dataset file to understand its structure before running further analysis.MIT
- Execute SQL queries on downloaded blockchain data files. Pass file paths from query_dataset results to analyze transaction or block data. Supports DuckDB for direct table references or read_parquet().MIT
- Remove or clear cached DuckDB data from Ontario open data queries. Specify a resource ID to remove one entry or use clear action to erase all cached data.MIT
- Generate example SQL queries for blockchain datasets using DuckDB. Streamline querying and schema inspection for Ethereum data with workflow tips. Enhance efficiency in blockchain data analysis.MIT