Natural language → SQL
Describe what you want; the LLM writes the SQL. Generate only so you can review it, or run it straight away. The dialect differences across five databases are already handled.
Self-hosted · No cloud · Source included
Ask your database in plain language.
The data never leaves the building.
AnyDB.ai is a self-hosted AI platform. Ask "show me today's open work orders" and it writes the SQL and runs it. The same system turns your LINE and Telegram accounts into support bots that actually answer. All of it runs on hardware you own — your database contents never go to anyone's cloud.
One-click Windows installer · No card required
Works with Oracle · MySQL · MSSQL · PostgreSQL · MariaDB
anydb — ask
You Show today's unclosed work orders, grouped by plant
SELECT f.plant_name, COUNT(*) AS open_tickets FROM work_orders w JOIN factories f ON f.id = w.plant_id WHERE w.status <> 'CLOSED' AND DATE(w.created_at) = CURDATE() GROUP BY f.plant_name ORDER BY open_tickets DESC;
3 plants · 47 open · 82ms
- 5
- databases supported
- 0
- rows sent to the cloud
- 3
- years to full open source
- 10+
- built-in plugins
Oracle / MySQL / MSSQL / PostgreSQL / MariaDB
The licence heartbeat carries a fingerprint, nothing else
BSL 1.1 → Apache 2.0
Available on every plan
Features
What it actually does for you
Not another chat window. AnyDB.ai puts asking your data, answering your customers, and doing the errands into one system you host yourself.
A system you can correct
When it gets one wrong, teach it: submit the bad SQL, the right SQL, and why. It remembers and applies that to similar questions. It fits your schema and your in-house jargon a little better every week.
Knowledge base and semantic index
It learns your schema and builds a vector index, so queries and support answers are grounded in your actual data (RAG) rather than guessed.
LINE / Telegram support bots
Connect an official account and you have 24-hour support. Public mode for customers, internal mode for staff, each with its own persona.
Hands off to a human
When the bot decides a person is needed, it pings an admin on Telegram. The admin types one reply and the system extracts and forwards it to the customer. The reply window stays open for 90 days.
AI personas
Support agent, data analyst, home assistant — define several personalities and map each channel to one. Tone and permissions stay separate.
Swappable LLM providers
OpenAI, Gemini and Anthropic each get their own key and enabled models. Switch whenever you like. Who you use, and which model, is your call.
Vector search over chat history
Pulls relevant context back across sessions. That table you discussed last week — it remembers the name.
Plugins
Built-in plugins
Toggle each one in the admin console. Every plugin works on every plan today — only the daily quota differs.
-
Telegram BOT
Support and internal-query bot with voice messages, account binding and human handoff.
-
LINE BOT
LINE official account support, public and internal modes, humans can take over any time.
-
GPT Image
Text-to-image generation.
-
Nano Banana Pro
Gemini image generation.
-
Vision OCR
Text recognition from images. Unlimited on every plan.
-
Voice chat
Speech to text, text to speech, and live voice conversation.
-
Remote Agent
Remote operation and delegated execution, with a full action log.
-
Google Places
"What's nearby" lookups, with a personal default location.
-
Google Routes
Route planning and travel-mode queries.
-
SSL certificates
Certificate issuance and management, enabled automatically over HTTPS.
Paid-plan-exclusive plugins are coming; we will announce them here.
Setup
How much of a pain is the install
Not much. One Windows installer, whether the system ends up on this machine or on a Linux box.
-
01
Run the installer
AnyDB_Installer.exe runs on Windows. Point it at this machine's WSL, or at a Linux host over SSH, and it brings up every Docker container on the target.
-
02
Connect your database
Enter the connection details; it scans the schema and builds the semantic index. Oracle through PostgreSQL, all fine.
-
03
Add your own LLM key
Pick one of OpenAI / Gemini / Anthropic, or enable all three. Usage bills to your account — we do not resell it.
-
04
Start asking
Ask from the web console, or wire up LINE / Telegram and let customers ask. Phones on the same network reach it too.
Privacy
Where does the data live? With you.
This is the single most important thing about the product, so here it is in detail.
Business data never leaves
Database contents, the SQL you run, the knowledge base, customer conversations — all of it stays on your machine. The licence server cannot see it and neither can we.
The heartbeat carries a fingerprint only
A paid subscription pings license.anydb.ai every 6 hours with the licence serial, a machine fingerprint (sss_id / instance_id) and a signature from a local private key. Offline, it validates for 48 hours against an embedded public key.
LLM calls use your own key
Your prompts go to the provider you chose and keyed. Who receives them, and whether the feature is on at all, is entirely up to you.
Containers talk over a private network
The knowledge-base database (MariaDB 12.3) publishes no port. The web renderer, support console and update runner sit on the internal Docker network. Only the service ports you need are exposed.
You can read the source
What ships inside the container is uncompiled Python. Read it, change it. There is no black box.
Fully open source in three years
Business Source License 1.1: every release converts to Apache 2.0 three years after it shipped. It is written into the licence — we do not get to change our minds.
Architecture
What the system looks like
Orchestrated with Docker Compose. Containers talk over an internal network; only what must be public is published.
| anydb-app | Main application | 8000 / 443 | FastAPI backend plus the Vue front end. All APIs, the admin console and webhook entry points. |
| anydb-db | Knowledge database | Internal only | MariaDB 12.3 holding the knowledge base, settings, conversations and vector index. |
| anydb-line-console | LINE support console | Internal only | Where human agents read conversations, take over and manage orders. |
| anydb-site-inspector | Web fetcher | Internal only | A Playwright rendering microservice behind the @site command. |
| anydb-updater | Update runner | Internal only | Executes the one-click automatic update. |
| anydb-nginx | Reverse proxy (optional) | 80 / 443 | Only needed when you terminate TLS on the same host. |
FAQ
Questions people actually ask
Is my data really not being sent anywhere?
Correct. The licence heartbeat carries a serial, a machine fingerprint and a signature — no business data at all. The LLM provider you enable does receive your prompts, because inference requires it, but that is your key with a vendor you chose. Features you never enable make no outbound calls.
What can the free plan do?
Every plugin works. The limits are quota: 10 stored sessions, 10 RAG knowledge graphs, 2 active AI personas, 1 enabled model per provider, 100 plugin calls a day, and 2 accounts. That is plenty to evaluate the product.
Do I have to be on Windows?
The server does not, the installer does. AnyDB_Installer.exe is a Windows program, but it can install the system into this machine's WSL or onto a Linux host over SSH - after which the Linux box is what runs, and Windows is out of the picture. The delivered bundle also ships docker/install.sh if you would rather install on Linux by hand.
Do I need my own OpenAI key?
Yes. AnyDB.ai does not resell API usage — which vendor you use and what you spend stays on your own account. That is also why you can switch provider or model whenever you want.
Will it change my database?
Only if you let it. You can configure it to generate SQL for review and never execute. How much you allow is set in the admin console.
How many devices can one account use?
Two — a computer and a phone, say. A third login signs out the oldest session with a notice. That is separate from how many people are licensed, which is the seat table.
Will an update wipe my settings?
No. Updates replace the application and front end only; data, settings and certificates are untouched. Database migrations are tracked by version, so only the ones that never ran are applied, and re-running is safe.
Can I modify the source? Can I resell it?
Modify, yes — your changes stay under the same licence and production use still needs a subscription. Reselling or offering it to third parties as a hosted service needs a separate commercial licence.
Just install it and have a look
The free plan needs no card, and the installer sorts out WSL2 and Docker for you. If you do not like it, delete it — everything was on your own machine the whole time.