NatureQuery for Supabase
Ask your Supabase database in plain English.
NatureQuery writes SQL for your Supabase project's Postgres database, runs it inside a read-only transaction, and gives you the answer as a table, a chart or a summary. When a number moves, the Analyst finds out why.
Any Supabase project, connected through its Session pooler address. Supabase's own root certificate is built in, so the connection is checked without anything to download.
Free plan: 50 AI questions a month. No card needed.
From a question
You ask in English. It writes Supabase.
An example of the SQL it writes: Postgres 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.
“New signups per week this month”
SELECT date_trunc('week', created_at) AS week,
COUNT(*) AS signups
FROM profiles
WHERE created_at >= date_trunc('month', now())
GROUP BY 1
ORDER BY 1;What it reads
What NatureQuery reads from Supabase.
- Your tables
- The tables in the public schema, where your app keeps its data, with their columns, types, primary keys and foreign keys.
- Enum values
- The allowed values of enum columns, so a filter says role = 'student' instead of guessing.
- Views
- For the Analyst, the views and materialized views in public, with the SQL behind them, so its numbers follow the definitions you already use.
- Not auth
- Supabase's own schemas, such as auth and storage, are not read. To ask about your users, keep a table of them in public, such as profiles.
- Checked first
- One statement at a time, reading commands only, and no functions that can change data or reach other servers.
- BEGIN READ ONLY
- Every query runs inside a read-only transaction, so Postgres itself refuses any write.
- Time limit
- A statement_timeout of 30 seconds on every query, and up to 1,000 rows on screen.
- Encrypted
- The connection is encrypted and checked against Supabase's root certificate, which NatureQuery carries.
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 in the Supabase SQL Editor, with a password of your own:
CREATE ROLE naturequery_reader WITH LOGIN PASSWORD 'choose-a-strong-password';
GRANT USAGE ON SCHEMA public TO naturequery_reader;
GRANT SELECT ON ALL TABLES IN SCHEMA public TO naturequery_reader;
ALTER DEFAULT PRIVILEGES IN SCHEMA public GRANT SELECT ON TABLES TO naturequery_reader;Through the Session pooler, its user name is naturequery_reader.your-project-ref. A table with Row Level Security on shows this user no rows until a policy lets it read them.
- 01
Copy the address
In Supabase, open your project, click Connect, and copy the Session pooler connection string.
- 02
Add a connection
On your NatureQuery dashboard, click Add connection under Connections and choose Supabase.
- 03
Paste it
Click Paste connection string. Supabase leaves [YOUR-PASSWORD] in place of your password, so type your database password in the Password field.
- 04
Test and ask
Click Test connection, then ask 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 Supabase 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
Supabase and NatureQuery.
- Why the Session pooler address?
- Supabase's direct connection address uses IPv6 on most projects, and many servers, NatureQuery's among them, connect over IPv4. The Session pooler works over both.
- Can NatureQuery change my Supabase data?
- No. Every query is checked before it runs and then runs inside a read-only transaction, so Postgres itself refuses any change. For full certainty, connect with a user that can only read.
- Can it see the users in auth.users?
- No. It reads your tables in the public schema, not Supabase's own schemas. Most apps keep a profiles table in public, and that is what it can ask about.
- Does Row Level Security apply?
- Yes, as for any connection: NatureQuery sees the rows that the user you connect with may read.
- Does the morning briefing work with Supabase?
- 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.
- Is there a free plan?
- Yes: 50 AI questions and 5 Analyst investigations a month on one database connection, with no card needed.