NatureQuery for MySQL
Ask your MySQL database in plain English.
NatureQuery writes MySQL for your question, runs it read-only with a time limit, and gives you the answer as a table, a chart or a summary. When a number moves, the Analyst finds out why.
Any MySQL server the internet can reach, such as Amazon RDS and Aurora, Google Cloud SQL, Azure or TiDB Cloud, plus MariaDB and PlanetScale, each with its own option.
Free plan: 50 AI questions a month. No card needed.
From a question
You ask in English. It writes MySQL.
An example of the SQL it writes: MySQL functions, your real table and column names, and the exact values your columns hold. The SQL is always shown, so you can check what was counted.
“Monthly revenue this year from completed orders”
SELECT DATE_FORMAT(order_date, '%Y-%m') AS month,
SUM(total_amount) AS revenue
FROM orders
WHERE status = 'completed'
AND order_date >= MAKEDATE(YEAR(CURDATE()), 1)
GROUP BY month
ORDER BY month;What it reads
What NatureQuery reads from MySQL.
- Tables and views
- The tables and views of the database you connect, with their columns, types, primary keys and foreign keys, so joins follow the links your database already has.
- ENUM values
- The values of ENUM columns, so a filter says status = 'paid' instead of guessing.
- View SQL
- For the Analyst, the SQL behind your views, so its numbers follow the definitions your reports already use. MySQL shows it to users with the SHOW VIEW privilege.
- Not your rows
- Writing a query needs only the structure. The few features that read result rows, such as the Analyst, are listed in the privacy policy.
- Checked first
- One statement at a time, reading commands only, and no functions that can change data or reach other servers.
- READ ONLY
- On MySQL and MariaDB servers that support it, every query runs inside START TRANSACTION READ ONLY, so the server itself refuses any write.
- Time limit
- max_execution_time of 30 seconds on MySQL (max_statement_time on MariaDB), and up to 1,000 rows on screen.
- Encrypted
- The connection is encrypted, and new connections check the server's certificate and host name.
Connect
Connected in a few minutes.
First, a user that can only read
For full certainty, connect with a user that can only read. Run this as an administrator, with a password of your own:
CREATE USER 'naturequery_reader'@'%' IDENTIFIED BY 'choose-a-strong-password';
GRANT SELECT, SHOW VIEW ON your_database.* TO 'naturequery_reader'@'%';SHOW VIEW lets the Analyst read the SQL behind your views. On PlanetScale, create a password with the Reader role instead.
- 01
Add a connection
On your NatureQuery dashboard, click Add connection under Connections and choose MySQL, or MariaDB or PlanetScale if your database runs there.
- 02
Paste the address
Click Paste connection string and paste mysql://user:password@host:3306/database, or fill in the host, port, database, user and password.
- 03
Test it
Click Test connection. If your provider signs its own certificates, as Amazon RDS does, turn on Trust this server's certificate. The connection stays encrypted.
- 04
Ask
Type a question in plain English, or ask the Analyst why a number changed.
The website connects only to public internet addresses. For a database on your own computer or office network, use NatureQuery Desktop for Windows.
NatureQuery Analyst
When a number moves, ask why.
The Analyst investigates your MySQL database with read-only queries, names what drove a change and the day it started, and links every figure to its query. On Pro and Enterprise it also writes a morning briefing on your database.
How the Analyst worksQuestions
MySQL and NatureQuery.
- Which MySQL databases does NatureQuery work with?
- Any MySQL server the internet can reach, such as Amazon RDS and Aurora, Google Cloud SQL, Azure or TiDB Cloud. MariaDB and PlanetScale each have their own option. For a database on your own computer or office network, use NatureQuery Desktop for Windows.
- Can NatureQuery change my MySQL data?
- It is built not to. Every query is checked before it runs, and on servers that support it, it runs inside a read-only transaction, so MySQL itself refuses any change. For full certainty, connect with a user that has only SELECT and SHOW VIEW.
- Which tables does it read?
- The tables and views of the database named in the connection. To work with another database on the same server, add a second connection.
- Does the morning briefing work with MySQL?
- Yes. On Pro and Enterprise, the morning briefing checks your sales, orders, refunds, duplicate orders and big customers going quiet every morning, and the Analyst explains what changed.
- Does NatureQuery copy my database?
- No. It reads the structure of your tables to write queries, and query results pass through to your browser without being stored.
- Is there a free plan?
- Yes: 50 AI questions and 5 Analyst investigations a month on one database connection, with no card needed.