# Tools

> Every listed resource, editors’ picks first. The filters below can be combined.

- Search: append `?q=<keywords>` to the URL. Separate several keywords with spaces; all of them must match. Matches name, repository, tags, professions, description and README.
- Filter by type: append `?type=<cli|skill|plugin|mcp>` to the URL.
- Filter by profession: append `?profession=<profession id>` to the URL. Separate several ids with commas; a resource matches when it suits any of them. Ids are listed at https://hebbmind.com/api/v1/professions
- Filter by tag: append `?tag=<tag>` to the URL. Separate several tags with commas; a resource must carry all of them. Tags are listed at https://hebbmind.com/api/v1/tags

Resources for ML / AI or Data analysis or Hardware engineering, Tagged `sql`: 29 items.

> - ML / AI: Model training, evaluation and LLM application development.
> - Data analysis: Querying, statistical analysis, reporting and visualization.
> - Hardware engineering: Part and assembly modeling, schematics and PCB review, simulation, and BOM and production files.

- [DuckDB](https://hebbmind.com/de/cli/duckdb.md): [CLI] In-process analytical SQL database. Its CLI queries CSV, Parquet and JSON files directly with SQL, no import or server needed, so agents can sample and aggregate large files. Officially maintained.
- [MCP Toolbox for Databases](https://hebbmind.com/de/mcp/mcp-toolbox.md): [MCP] Google's open-source database MCP server with ready-made query and SQL tools for dozens of sources, including PostgreSQL, MySQL, BigQuery, Spanner and MongoDB. Define controlled custom queries in tools.yaml.
- [SQL Queries](https://hebbmind.com/de/skill/sql-queries.md): [Skill] Anthropic's official data skill that guides agents to write, translate and optimize SQL across Snowflake, BigQuery, Databricks, PostgreSQL and other warehouse dialects, including CTEs, window functions and analytical aggregations.
- [Data](https://hebbmind.com/de/plugin/data.md): [Plugin] Data analysis plugin: writes queries in each SQL dialect, explores datasets, runs statistical tests, charts with Python and builds interactive HTML dashboards, then reviews methods and conclusions before sharing. Connects to Snowflake, BigQuery and other warehouses. Official from Anthropic.
- [BigQuery Basics](https://hebbmind.com/de/skill/bigquery-basics.md): [Skill] Manages BigQuery datasets, tables and jobs with the bq and gcloud CLIs, runs SQL queries and loads data, with references for client libraries, MCP and Terraform. Google's official skill; requires a Google Cloud project.
- [dbt](https://hebbmind.com/de/cli/dbt.md): [CLI] Command-line framework for warehouse modeling and ELT transformations: write models in SQL and let dbt handle dependencies, data tests and documentation. v2 is rewritten in Rust as a single binary. Maintained by dbt Labs; needs a data warehouse connection.
- [pgcli](https://hebbmind.com/de/cli/pgcli.md): [CLI] PostgreSQL command-line client with smart autocompletion and syntax highlighting. Compatible with psql environment variables, and -c runs a statement and exits, so agents can query databases non-interactively.
- [mycli](https://hebbmind.com/de/cli/mycli.md): [CLI] MySQL terminal client with smart autocompletion and syntax highlighting, also compatible with MariaDB and TiDB. Supports --execute and batch mode with CSV or table output, so agents can run SQL directly.
- [Datasette](https://hebbmind.com/de/cli/datasette.md): [CLI] Publishes SQLite databases as browsable, queryable web pages and JSON APIs, with SQL queries, metadata and plugins, and deploys to Cloud Run and other platforms with datasette publish. Great for data exploration and data journalism. Needs Python 3.10+.
- [usql](https://hebbmind.com/de/cli/usql.md): [CLI] Universal psql-style SQL command line: one tool to connect to PostgreSQL, MySQL, SQLite, SQL Server, Oracle and dozens of other SQL and NoSQL databases, with support for copying data between databases.
- [SQLFluff](https://hebbmind.com/de/cli/sqlfluff.md): [CLI] Linter and formatter for 20+ SQL dialects that auto-fixes most issues and handles Jinja templating and dbt projects (dbt needs a plugin), suited to warehouse code review and CI.
- [Steampipe](https://hebbmind.com/de/cli/steampipe.md): [CLI] Query cloud resources and SaaS APIs live with SQL: plugins map AWS, Azure, GCP, GitHub, Kubernetes and other services to tables you can select from directly, no ETL needed. A single binary with Postgres built in.
- [Jupyter Notebooks](https://hebbmind.com/de/skill/jupyter-notebook.md): [Skill] Creates, edits and validates reproducible Python and SQL Jupyter notebooks: organizes cells as reports or tutorials, checks conclusions against actual output and reruns top to bottom before handoff. Maintained by OpenAI in the Data Analytics plugin of openai/plugins.
- [DBHub](https://hebbmind.com/de/mcp/dbhub.md): [MCP] One server connecting PostgreSQL, MySQL, MariaDB, SQL Server, Oracle and SQLite, exposing just two tools by default to save context, with read-only mode and SSH tunneling. From Bytebase.
- [SQLMesh](https://hebbmind.com/de/cli/sqlmesh.md): [CLI] Framework for writing data transformation models in SQL or Python, with a Terraform-like plan/apply flow, virtual data environments, unit tests and table diffs, and transpilation across 10+ SQL dialects. A Linux Foundation project and an alternative to dbt.
- [sqlite-utils](https://hebbmind.com/de/cli/sqlite-utils.md): [CLI] A CLI and Python library by Simon Willison: imports JSON and CSV straight into SQLite with automatic table creation, runs in-memory SQL queries over files, and supports full-text search and table transformations.
- [MySQL MCP Server](https://hebbmind.com/de/mcp/mysql-mcp-server.md): [MCP] Gives agents controlled access to MySQL: list databases and tables, inspect schemas and sample data, and run SQL, with multi-database mode, SSL and SSH tunnels. Configure your own database user, ideally with least privilege.
- [ClickHouse MCP Server](https://hebbmind.com/de/mcp/mcp-clickhouse.md): [MCP] Runs SQL queries against ClickHouse and browses databases and table schemas, read-only by default; can also enable embedded chDB to query data directly in files and URLs. Maintained by ClickHouse.
- [dbt Agent Skills](https://hebbmind.com/de/skill/dbt-agent-skills.md): [Skill] dbt Labs' official skills: write and edit dbt models, add unit tests and docs, set up the MetricFlow semantic layer, debug failed jobs, and handle dbt version upgrades and cross-platform migrations. Most skills need dbt installed and an existing project.
- [dbt Agent Skills](https://hebbmind.com/de/plugin/dbt-agent-skills.md): [Plugin] dbt Labs' official plugin marketplace with dbt and dbt-migration plugins: write models and unit tests, build semantic-layer metrics, govern with dbt Mesh, debug failed jobs, and handle version upgrades and cross-platform migrations. Most skills need an existing dbt project.
- [GeoSQL](https://hebbmind.com/de/skill/geosql.md): [Skill] Helps agents write geospatial SQL for PostGIS, DuckDB, BigQuery and Snowflake: inspect schemas and keep query costs in check, then render results as interactive maps to review and correct. Needs Python and your own database or warehouse; maps use Dekart, which can run locally in Docker.
- [DuckDB Skills](https://hebbmind.com/de/skill/duckdb-skills.md): [Skill] Official DuckDB skills: query local or S3 CSV, Parquet, Excel and JSON files with SQL or plain language, attach databases, convert formats, analyze spatial data and look up documentation. Needs the DuckDB CLI; tested only on macOS and Linux.
- [dbt MCP Server](https://hebbmind.com/de/mcp/dbt-mcp.md): [MCP] Lets agents read dbt project models, lineage and Semantic Layer metrics, run build, run and test commands, and call the dbt platform Discovery and Admin APIs. Maintained by dbt Labs; Semantic Layer and platform tools need a dbt platform account.
- [ClickHouse Agent Skills](https://hebbmind.com/de/skill/clickhouse-agent-skills.md): [Skill] Official ClickHouse skills: best practices for schema design, primary keys, JOINs and inserts ranked by impact, advice on real-time architecture decisions, in-process SQL and pandas-compatible analysis with chDB, and local and cloud deployment workflows.
- [NetSuite AI Companion](https://hebbmind.com/de/plugin/netsuite-ai-companion.md): [Plugin] Official Oracle NetSuite plugin for the AI Connector: has AI use standard reports and saved searches first, applies debit/credit, multi-subsidiary consolidation and currency rules, and safety-checks SuiteQL to avoid reporting errors. Needs NetSuite with AI Connector; finance should verify.
- [Databricks Agent Skills](https://hebbmind.com/de/skill/databricks-agent-skills.md): [Skill] Official Databricks skills guiding agents to build Lakeflow pipelines and jobs, Apps, Lakebase, Vector Search, Model Serving and AI/BI dashboards on the lakehouse. Needs the Databricks CLI.
- [Apache Doris MCP Server](https://hebbmind.com/de/mcp/doris-mcp-server.md): [MCP] Apache Doris's official MCP: gives agents read-only access to explore table metadata, run and explain SQL, diagnose slow queries, and check cluster status, load jobs and data governance info. Needs Python 3.12+ and Doris 2.0 or later.
- [Google Ads API Developer Assistant](https://hebbmind.com/de/plugin/google-ads-api-developer-assistant.md): [Plugin] Official Google Ads API assistant: ask in plain language, generate and validate GAQL queries, run them to export account data to CSV, and debug offline conversion uploads. Account-changing code is generated, not run. Needs a developer token, credentials file and Python 3.10+.
- [Snowflake Cortex Code](https://hebbmind.com/de/plugin/cortex-code.md): [Plugin] Snowflake's official plugin: detects Snowflake-related requests and hands them to the Cortex Code CLI, whose 55+ built-in skills handle SQL, dynamic tables, data governance and more. Needs the cortex CLI installed and a Snowflake connection configured.
