I’ve been working on Coomia DataGPT, a self-hosted AI copilot for data analysis.
It lets you connect directly to databases like PostgreSQL, MySQL, Trino, and Doris, and ask questions in plain English —
DataGPT automatically generates SQL, runs the query, and visualizes the results as charts or tables.
How it works
Connect your database (PostgreSQL, MySQL, Trino, Doris, etc.)
Ask questions in natural language (e.g., “Which product categories generated the most revenue last month?”)
DataGPT writes the SQL automatically
The query runs, and the result appears as an interactive chart
You can save and share queries with your team
It’s fast, private, and self-hosted — built for teams that want AI analytics without sending data to external APIs.
We wanted a data copilot that doesn’t require sending your sensitive data to the cloud.
Coomia DataGPT runs entirely in your environment, giving you full control over security and performance.
I’ve been working on Coomia DataGPT, a self-hosted AI copilot for data analysis. It lets you connect directly to databases like PostgreSQL, MySQL, Trino, and Doris, and ask questions in plain English — DataGPT automatically generates SQL, runs the query, and visualizes the results as charts or tables.
How it works
Connect your database (PostgreSQL, MySQL, Trino, Doris, etc.)
Ask questions in natural language (e.g., “Which product categories generated the most revenue last month?”)
DataGPT writes the SQL automatically
The query runs, and the result appears as an interactive chart
You can save and share queries with your team
It’s fast, private, and self-hosted — built for teams that want AI analytics without sending data to external APIs.
Tech Stack
Backend: Python + FastAPI
Frontend: React + TypeScript
LLM: OpenAI / local model options
Databases: PostgreSQL, MySQL, Trino, Doris, Clickhouse
Deployment: Docker (one line to start)
Why self-hosted?
We wanted a data copilot that doesn’t require sending your sensitive data to the cloud. Coomia DataGPT runs entirely in your environment, giving you full control over security and performance.
Try it
https://coomia.com/docs.html
You can see a short demo video here: https://youtu.be/8opQUD109mY
I’d love your feedback — especially on:
usability and latency
SQL generation quality
database connection setup
what integrations you’d like to see next
Thanks for reading! — The Coomia Team