Find the right AI tools for any job, task or industry.DATABASES & DATA ENGINEERING · PRACTITIONER
ETL developer
AI tools to consider for an ETL developer 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: ELT developer data integration developer SSIS Informatica
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 an ETL developer 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 →