SQLBot
Ask your database questions in plain words and get tables and charts.
No server needed to start: Cloudgate can provide one. What happens when you click Deploy
What is SQLBot?
Self-hosted SQLBot answers questions about your database in plain language with SQL, tables and charts, using the AI model you choose.
SQLBot is a self-hosted AI tool that answers questions about your database in plain language, an alternative to ThoughtSpot and Julius AI: you type a question, and it writes the SQL, runs it and shows the answer as a table and a chart. It is made by FIT2CLOUD, the team behind DataEase.
You connect a database such as MySQL, PostgreSQL or SQL Server, or upload a spreadsheet, and choose an AI provider: OpenAI, DeepSeek, Gemini or a model you run yourself. You can teach it your business terms and example queries so its answers get closer to how your team works. The owner of an online bakery, for example, could ask "which products sold best in York last quarter?" and pin the chart to a dashboard, without writing SQL or waiting for a report.
SQLBot is free to use, with code published under a modified GPLv3 licence that requires keeping its logo; branding, custom prompts, LDAP or OIDC sign-in and audit logs need a paid licence. Your AI provider sees your questions and the results it explains.
Cloudgate installs SQLBot on a server Cloudgate provides or one you connect and gives it a secure web address. Sign in with the default admin account and change its password at once, then add your AI provider and your first data source.
What you can do with SQLBot
- Ask in plain language Type a question such as "sales by product last month" and get the SQL, a table of results and a chart.
- Connect the database you have MySQL, PostgreSQL, SQL Server, Oracle, ClickHouse, Redshift, Elasticsearch and more, or upload an Excel or CSV file.
- Choose your AI provider Use OpenAI, DeepSeek, Gemini, Azure OpenAI or any OpenAI-compatible service, including a model you run yourself.
- Teach it your business words Add a glossary of your terms and example queries, so answers match how your team talks about its numbers.
- Keep data separate Workspaces keep each team's data sources apart, and row-level permissions limit what each person can see.
- Pin answers to dashboards Save the charts you ask for often and arrange them on a dashboard.
- Add it to other apps Embed the assistant in another web page or as a pop-up. SQLBot's MCP server for n8n or Dify is not given a web address by this template.
Replaces ThoughtSpot and Julius AI
SQLBot does the same job as ThoughtSpot and Julius AI. Here is what changes when you switch.
- No fee per user for SQLBot itself; you pay your server and your AI provider
- Your database stays on your servers, and you choose which AI provider sees questions and results
- Works with a model you run yourself for full control
- Connects to a long list of databases and to Excel files
- Far fewer reporting and analysis features than a full BI or data-analysis service
- Answers can be wrong, so check the query behind important numbers
- The SQLBot logo must stay, and branding, custom prompts, LDAP or OIDC sign-in and audit logs need a paid licence
- Some documentation is only in Chinese, and the admin account may start with Chinese menus
What happens when you click Deploy?
You do not need a server or any technical knowledge. Four steps, and SQLBot is running at its own web address.
- Step 1 Click Deploy and create your account
Deploy takes you to Cloudgate. Create an account, or log in if you have one. SQLBot itself is free.
- Step 2 Choose a server
No server? Get one from Cloudgate: pick a size and a country, and Cloudgate gets it ready. Already have one? Connect it instead.
- Step 3 Cloudgate sets up SQLBot
It prepares the server, makes the passwords the app needs and starts it. There is nothing to install and nothing to write down.
- Step 4 Open your app and sign in
Your app gets a free web address to start, without https. Add your own domain, like app.yourshop.com, and Cloudgate secures it with https for you.
New to Cloudgate? See what Cloudgate is
Run Cloudgate yourself? Deploy from your own console
In your Cloudgate console, open Templates and choose SQLBot.
Questions
Is SQLBot free?
Yes, SQLBot is free to use, and its code is public under a modified GPLv3 licence that says you must keep the SQLBot logo and copyright notice. You pay for your server and your AI provider. A paid licence from its maker, FIT2CLOUD, adds custom branding, custom prompts, LDAP or OIDC sign-in and audit logs.
Is SQLBot open source?
Not in the usual sense. SQLBot's code is public under GPLv3 with an extra rule against removing or changing the logo and copyright notice, and it relies on a closed-source add-on for some features.
How do I sign in to SQLBot the first time?
Sign in with the username admin and SQLBot's published default password, SQLBot@123456, and change it at once from your profile menu, because anyone who finds the address could otherwise sign in. The new password needs 8 to 20 characters with upper and lower case letters, a digit and a symbol. If the menus are in Chinese, switch the language in the same menu.
Which databases can SQLBot connect to?
SQLBot connects to MySQL, PostgreSQL, Microsoft SQL Server, Oracle, ClickHouse, Apache Doris, StarRocks, Apache Hive, Amazon Redshift and Elasticsearch, and you can upload Excel or CSV files.
Does SQLBot send my data to an AI company?
Partly. SQLBot sends your questions, table descriptions and the results it needs to explain to the AI provider you set up; the database itself stays where it is. To keep everything in-house, connect a model you run yourself through an OpenAI-compatible server.
Is SQLBot a good alternative to ThoughtSpot?
Yes, SQLBot suits a small team that mainly wants to ask its own database questions in plain language without a per-user subscription. ThoughtSpot is a much larger hosted analytics service with more reporting, sharing and governance features.
Can I import my ThoughtSpot setup into SQLBot?
No, there is no ThoughtSpot importer. SQLBot connects to the same databases directly, so you connect each one with a read-only account, describe its main tables and add a glossary of your business terms, then check answers against your existing reports.
What server size do I need for SQLBot?
SQLBot needs a medium server with about 2 GB of memory and several gigabytes of disk, because it includes its own database and a model for searching your table descriptions. The AI answers come from your AI provider, so no graphics card is needed.
Do I need technical skills to run SQLBot?
No. Click Deploy, create your Cloudgate account and choose a server, and Cloudgate sets up SQLBot and gives it a web address. You use it in your browser like any other online tool.
Do I need my own server for SQLBot?
No. When you deploy SQLBot, hosted Cloudgate can provide a server. If you already rent one, you can connect it instead.
Related apps
A self-hosted AI agent with its own computer that does tasks for you.
Private AI chat over your own documents, for staff and your website.
One private AI chat for many models, using your own API keys.
Build Coze-style AI agents, chatbots and workflows on your server.