Find the right AI tools for any job, task or industry.DATABASES & DATA ENGINEERING · PRACTITIONER
Data engineer
AI tools to consider for a data engineer include dbt, Informatica CLAIRE, Gemini in BigQuery and Keboola. They support tasks common in this work: build data pipelines & warehouses, write & review SQL and design schemas & data models.
Also known as: ETL data pipelines
Build data pipelines & warehouses
Move, transform, test, and orchestrate data for analysis.
| Tool | What it does | Pricing | Type | Evidence |
|---|---|---|---|---|
| API.SHNot verified | Public web data as JSON from around 1,000 websites: search, social media, e-commerce, jobs and more. | Pricing not verified | Tool + MCP | Site checked |
| doc2jsonNot verified | Turn PDFs and photos into typed JSON with your own schema. Missing values come back null. | Pricing not verified | Tool + MCP | Site checked |
| LLMtoMDNot verified | Convert PDFs, Office docs, websites and audio into AI-ready Markdown, then search and ask your docs. | Pricing not verified | Tool + MCP | Site checked |
| OCR-AINot verified | Hebrew and English OCR for PDFs and images: text, key fields and tables, page by page. | Pricing not verified | Tool + MCP | Site checked |
| ForumDataAPINot verified | Real-time community forum posts, search, nested comments & mentions MCP. OAuth or API key. | Pricing not verified | Tool + MCP | Site checked |
| AirbyteAirbyte | Open-source data movement from hundreds of sources, with a connector builder. | Open source | Tool + MCP | Site checked |
| AstronomerAstronomer | Managed Apache Airflow for orchestrating data pipelines. | Usage based | Tool | Site checked |
| DagsterDagster Labs | Data orchestrator built around data assets, with lineage and observability. | Open source | Tool | Site checked |
Write & review SQL
Draft, explain, and check SQL queries against a real schema.
| Tool | What it does | Pricing | Type | Evidence |
|---|---|---|---|---|
| DocQueryNot verified | Read-only MCP over your Excel or Airtable plus the PDFs beside it, joined as one relational dataset. | Pricing not verified | Tool + MCP | Site checked |
| SheetDBNot verified | Read and write Google Sheets rows via SheetDB APIs; per-API agent permissions, approved deletes. | Pricing not verified | Tool + MCP | Site checked |
| TblFlowNot verified | Lisez et modifiez vos bases TblFlow (PostgreSQL), recherchez vos documents, lancez vos agents. | Pricing not verified | Tool + MCP | Site checked |
| OrionBINot verified | Query your own databases and Data Sets with read-only SQL, and build hosted dashboards. | Pricing not verified | Tool + MCP | Site checked |
| AI2SQLAI2SQL | Generates SQL from natural language for common databases. | Paid | Tool + MCP | Site checked |
| MetabaseMetabase | Open-source business intelligence with natural-language questions. | Open source | Tool | Site checked |
| ThoughtSpotThoughtSpot | AI analytics agent that answers questions from warehouse data. | Paid | Tool | Site checked |
| VannaVanna AI | Open-source framework for building data agents that turn questions into SQL, with user-scoped access. | Open source | Tool + MCP | Site checked |
Design schemas & data models
Model tables and relationships, and review schema changes.
| Tool | What it does | Pricing | Type | Evidence |
|---|---|---|---|---|
| ChartDBChartDB | Open-source database diagram editor that visualises schemas and exports DDL. | Open source | Tool | Site checked |
| dbdiagramHolistics | Draws entity relationship diagrams from a simple text language. | Free + paid | Tool | Site checked |
| HackoladeHackolade | Data modelling for NoSQL, SQL and API schemas. | Paid | Tool | Site checked |
| ErdDocsNot verified | ER diagrams from SQL, Prisma or ORM models. One tool, no account, nothing stored. | Pricing not verified | MCP | Site checked |
| toro4nNot verified | Draw, shape, and edit Neo4j graph data models in toro4n with your AI assistant. | Pricing not verified | Tool + MCP | Site checked |
| AtlasAriga | Manages database schemas as code with planned and linted migrations. | Free + paid | Tool | Site checked |
| BytebaseBytebase | Database change management with review workflows and SQL checks. | Free + paid | Tool | Site checked |
| Informatica CLAIREInformatica | AI assistance across enterprise data integration, quality and governance. | Contact sales | Tool | Site checked |
Fields this role works in
Common questions
What AI tools can a data engineer use?
dbt, Informatica CLAIRE, Gemini in BigQuery, Keboola and API.SH are good places to start. Tasks they support in this work include: build data pipelines & warehouses, write & review SQL and design schemas & data models.
How should AI output be checked in this role?
Treat it as a draft. Confirm facts, figures, and citations against the original source, and keep accountable decisions with a qualified person. Check the vendor’s data terms before sharing anything confidential.
No paid ranking. Reviewed 2026-11-04. Tool fit is an editorial suggestion based on published capabilities. See sources & methodology →