The request is to write SQL, so the best fit is a tool that actually writes or executes queries. LangChain offers a query-writing action 1, and dbt builds and validates SQL transformations 4; ClickHouse 3 and DuckDB 8 run SQL directly, while SQLFluff 2 lints and formats it.
- 1
LangChainlangchain.comverified and signed
Writes and executes SQL queries from simple SELECTs to complex multi-table JOINs, aggregations and subqueries via its query-writing action 1.
+163 community tools built for it
for agents: query-writing · schema-exploration · push_prompt
- 2
dbtgetdbt.comverified and signed
Writes SQL transformations using ref() and source(), creates tests and validates results for data models 4.
for agents: using-dbt-for-analytics-engineering · adapters · adapter
- 3
ClickHouseclickhouse.comverified and signed
Runs analytical SQL against ClickHouse through its SQL actions and official SDKs such as clickhouse-connect 3.
official:MCP server · ClickHouseSDK · clickhouse-connectrepository · data-agent-mnistskill · buildSDK · @clickhouse/client+28 community tools built for it
for agents: chdb-sql · sql · sql
- 4
- 5
Sources
- 1LangChain: the open agent platform to own your intelligencelangchain.com · read 2026-10-29
- 2SQLFluffsqlfluff.com · read 2026-10-29
- 3Fast Open-Source OLAP DBMS | ClickHouseclickhouse.com · read 2026-10-29
- 4Deliver trusted data with dbt | dbt Labsgetdbt.com · read 2026-10-29
- 8An analytical SQL database management system – DuckDBduckdb.org · read 2026-10-29
For agents: the 10 actions behind this answer
query-writing · query-writing verified and signed
Writes and executes SQL queries from simple SELECTs to complex multi-table JOINs, aggregations, and subqueries. Use when the user asks to query a database, write SQL, run a SELECT statement, retrieve data, filter records, or generate reports from database tables.
sql · sqlfluff verified and signed
chdb-sql · chdb-sql verified and signed
Use when the user wants to run SQL — especially analytical SQL — on local files (parquet/csv/json), URLs, S3 paths, or remote databases (Postgres, MySQL, MongoDB, ClickHouse Cloud, Iceberg, Delta Lake) without setting up a server. Provides chDB — embedded ClickHouse SQL in Python with 1000+ function
using-dbt-for-analytics-engineering · using-dbt-for-analytics-engineering verified and signed
Builds and modifies dbt models, writes SQL transformations using ref() and source(), creates tests, and validates results with dbt show. Use when doing any dbt work - building or modifying models, debugging errors, exploring unfamiliar data sources, writing tests, or evaluating impact of changes.
Connector · MySql.Data verified and signed
· SQLAlchemy website read, tools not yet checked
The Database Toolkit for Python
Manage alerts · Pydantic verified and signed
Configure SQL-based alerts that periodically run and notify channels when results match. Inspect alert history and current firing state.
SQL · duckdb verified and signed
· sqlc.dev website read, tools not yet checked
Compile SQL to type-safe code
· Grain website read, tools not yet checked
Run SQL queries and inspect database schemas through safe, visible MCP tools.
Labels are the instruments' verdict and are never changed by ranking. Agents and robots get this same answer as JSON at /api/v1/find?q=…&answer=1 and through the MCP server.