NatureQuery for SQL Server
Ask your SQL Server database in plain English.
NatureQuery writes T-SQL for your question, runs the single read-only query it wrote, and gives you the answer as a table, a chart or a summary. When a number moves, the Analyst finds out why.
Any SQL Server the internet can reach: Azure SQL Database, Azure SQL Managed Instance, Amazon RDS for SQL Server, Google Cloud SQL for SQL Server, or a self-hosted server. Sign in with a SQL Server login and password (Windows Authentication is not available over the internet).
Free plan: 50 AI questions a month. No card needed.
From a question
You ask in English. It writes SQL Server.
An example of the SQL it writes: T-SQL 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 FORMAT(order_date, 'yyyy-MM') AS month,
SUM(total_amount) AS revenue
FROM orders
WHERE status = 'completed'
AND order_date >= DATEFROMPARTS(YEAR(GETDATE()), 1, 1)
GROUP BY FORMAT(order_date, 'yyyy-MM')
ORDER BY month;What it reads
What NatureQuery reads from SQL Server.
- Tables
- The tables in the dbo schema, with their columns, types and primary keys.
- The dbo schema
- It reads the dbo schema of the database you connect. Tables in other schemas are not read yet.
- Not your rows
- Writing a query needs only the structure. The few features that read result rows, such as the Analyst (up to 20 rows per query), are listed in the privacy policy.
- Checked first
- Every query is checked before it runs: one statement, reading commands only, and no functions that can change data or reach other servers.
- A read-only login
- SQL Server runs each query as the login you connect with, so connect with one that can only read (db_datareader). Then nothing can change your data, whatever happens.
- Time limit
- Thirty seconds per query, and up to 1,000 rows on screen.
- Encrypted
- The connection is always encrypted, and new connections check the server's certificate.
Connect
Connected in a few minutes.
First, a user that can only read
SQL Server runs each query as the login you connect with, so a read-only login is the real safeguard. Create one as an administrator (run the lines after GO inside the database you will connect):
CREATE LOGIN naturequery_reader WITH PASSWORD = 'choose-a-strong-password';
GO
USE your_database;
CREATE USER naturequery_reader FOR LOGIN naturequery_reader;
ALTER ROLE db_datareader ADD MEMBER naturequery_reader;db_datareader grants read access to every table. On Azure SQL Database, skip the USE line and create the user in the database you connect to.
- 01
Add a connection
On your NatureQuery dashboard, click Add connection under Connections and choose SQL Server.
- 02
Fill in the details
Enter the server host, port 1433, the database name, and the read-only login and password.
- 03
Test it
Click Test connection. The connection is encrypted; if your server uses a self-signed certificate, turn on Trust this server's certificate.
- 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 SQL Server 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
SQL Server and NatureQuery.
- Which SQL Server databases does NatureQuery work with?
- Any SQL Server the internet can reach: Azure SQL Database, Azure SQL Managed Instance, Amazon RDS for SQL Server, Google Cloud SQL for SQL Server, and self-hosted servers. For a server on your own network, use NatureQuery Desktop for Windows.
- Can NatureQuery change my data?
- Every query is checked before it runs: one statement, reading commands only. SQL Server runs it as the login you connect with, so for full certainty connect with a read-only login (db_datareader). Then nothing can change your data.
- Which tables does it read?
- The tables in the dbo schema of the database you connect, with their columns, types and primary keys. Other schemas are not read yet.
- Does the morning briefing work with SQL Server?
- 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.