Nova AI · your data analyst

Ask your data anything. Nova writes the SQL.

Nova is the text-to-SQL analyst built into Query Streams. Ask in plain English — Nova reads your real schema, writes validated SQL, runs it read-only through your Network Agent, and answers with metrics, tables and charts. No hallucinated columns, no separate BI license.

On Business & Enterprise · monthly Nova credits, then pay-as-you-go · 30-day trial
Reads your real schema Runs read-only via your agent Charts on demand 10 SQL dialects

Watch Nova work

It talks back like an analyst — metrics, a breakdown table, the SQL it wrote, and charts on demand — then saves the query for your team.

Nova Nova PostgreSQL · read-only
You
How are monthly sales trending? Which product categories are growing fastest?
Nova
schema columns query chart
I analysed your sales_orders and product_categories tables over the last 6 months. Revenue is up across the board, led by Electronics:
$2.41MRevenue+18.3%
$156.20Avg order+8.1%
15,442Orders+9.4%
CategoryRevenueGrowth
Electronics$842K+34.2%
Home & Garden$391K+22.7%
Sports & Outdoor$287K+19.1%
Apparel$445K+6.3%
Electronics is your standout — a 52% surge in Q1. Home & Garden is accelerating too; it overtook Sports & Outdoor in February. Here’s the query I ran:
Monthly sales by category RunSaveCopy
SELECT pc.category_name,
       SUM(so.total_amount)         AS revenue,
       COUNT(*)                     AS orders,
       ROUND(AVG(so.total_amount),2) AS avg_order
FROM   sales_orders so
JOIN   product_categories pc ON so.category_id = pc.id
WHERE  so.order_date >= CURRENT_DATE - INTERVAL '6 months'
GROUP BY pc.category_name
ORDER BY revenue DESC;
Monthly revenue Prior qtrCurrent qtr
Oct
Nov
Dec
Jan
Feb
Mar
You
Plot the 6-month revenue trend as a line
Nova
chart
Here’s the trajectory — up and to the right since December. The current quarter is pacing about 22% above the prior one.
Revenue trend · last 6 monthsRevenue
OctNovDecJanFebMar
You
Save it for my sales team to run in Excel
Nova
save
Saved Monthly Sales by Category with @start_date, @end_date and @region filters. Your sales team can run it live from Excel or Google Sheets — no SQL needed.
Saved to Query Builder
Ask Nova anything about your data…

An illustrative conversation with sample data.

Why Nova gets it right

Generic text-to-SQL tools guess at your tables. Nova works from your real database, executes safely, and finishes the job.

Knows your real tables

Nova works from your actual columns, types and keys — so it never invents a column. Run Schema Intelligence once and it also learns your enums, relationships and business domains for even sharper SQL.

Runs live, read-only

Nova executes through the same outbound-only Network Agent, with a read-only validator at the agent. You get real results — and your credentials and data never leave your network.

Charts, then share

Ask for a bar, line, pie or scatter chart and Nova renders it inline. Save any answer to the Query Builder so the whole team can run it from Excel, Sheets or Smartsheet.

The edge

Nova and your agent are one system.

Most AI tools bolt onto a database through a generic driver and hope. Nova talks straight to the Query Streams Network Agent — which ships custom, AI-catered functions built for exactly this. No middleman, no exports, nothing copied out of your network. That pairing is what sets us apart.

Purpose-built agent functions

Schema discovery, smart query execution, data sampling and relationship mapping are hardcoded into every agent — read-only, AI-catered, and far faster than raw SQL loops.

One compressed round-trip

Where generic tools fire 15+ queries to understand a table, the agent returns a full profile in a single LZ4-compressed call — so Nova reasons over real context, fast.

Direct & real-time

Nova reaches your live data through the agent you already run — in real time, with no data exports and no copies of your database sitting anywhere else.

Optional · one-time

Teach Nova your data — once.

Run Schema Intelligence a single time and Nova learns your real structure, relationships, enum labels and business domains. From then on it writes sharper, more accurate SQL — and it’s incremental, so re-runs only touch the tables that changed.

01

Recon

Scans your schema structure, columns and foreign keys — at zero token cost.

02

Profile

Your Network Agent runs one optimized profiling call per table.

03

Analyze

Parallel AI workers read each table with real data context.

04

Synthesize

A cross-table pass discovers implicit joins and normalizes the taxonomy.

One profiling call per table captures

Distinct counts NULL rates Enum detection Value distribution Min / max ranges Sample values Boolean patterns Emails · currencies · IDs

So Nova then knows

  • Plain-English questions map to accurate SQL
  • Enum labels, join paths & business domains
  • Which tables are facts, dimensions & lookups
  • Implicit relationships across your whole schema
Read-only — your data is never modified PII-aware — passwords, SSNs & keys excluded from sampling Incremental — skips tables already covered
How Nova is priced

Pay for the analysis you actually do.

Every Business and Enterprise plan includes a monthly allowance of Nova credits to get you started. Beyond that, Nova is pay-as-you-go — a heavy analytics month simply costs a little more, billed on usage like everything else in Query Streams. No per-seat fees, no lock-in.

Monthly Nova credits included Pay-as-you-go beyond No per-seat fees

Just ask, in plain English

No SQL required. Nova handles the schema, the syntax and the execution — you ask the question.

Top 10 customers by revenue this quarter Chart monthly signups for 2026 Which products are trending week over week? Find orders with no matching invoice What’s our Stripe MRR this month? Show accounts that churned since April
For the whole team

Not just for DBAs.

Nova isn’t locked to database admins. A teammate signs up with an email address on your company domain and appears in your user list — then the account creator or an administrator switches on Nova access for them, one person at a time. Non-technical teammates get Concierge Mode: they ask in plain English and get answers and charts back, never SQL. Ask for a report and Nova builds it, saves it and shares it out itself — no query to save, no share step to find. It simply arrives in the right people’s Excel or Google Sheets add-on. Every query still runs read-only through your own Agent, and you decide exactly who can ask.

Teammate signs up on your company domain You grant Nova access per person Concierge Mode — plain English, zero SQL Nova saves & shares the report itself Read-only & governed — you stay in control

Concierge Mode: a data analyst for everyone.

Your team doesn’t get a SQL editor — they get Nova. It answers the question, then turns the answer into a living report they can open in their own spreadsheet. Creators and administrators can switch into the same view whenever they want it.

01

They just ask

“What sold best last month?” Nova reads your schema, writes the query, runs it read-only and explains the answer as a table or a chart. No SQL is shown, and there’s nothing to configure.

02

Nova saves and shares it

Like an answer? Nova builds the report, saves it and shares it out itself — there’s no query to save and no share step to hunt for. Name a teammate (or someone outside your company) and they’re on it too, with the usual email.

03

It opens in their sheet

The report appears in the Excel add-in and the Google Sheets add-on under Shared Queries. Change a filter, hit Run, and live results stream into the cells. Nova writes it to be reusable — a customer dropdown, a date range, a status list — so one report answers many questions, and every later change needs their approval first.

Members never see SQL or your schema Adjustable filters on supported connectors Read-only through your own Network Agent

Nova queries all 53 of your sources

38 database connectors and 8 API connectors — the same secure Agent, now answering questions. And when the answer lives in more than one database, Nova drafts a federated query across the connections you name, explains any refusal in plain words, then runs the cross-source report and charts the joined result.

Microsoft SQL ServerPostgreSQLMySQLMariaDBOracleSnowflakeGoogle BigQuerySQLiteMicrosoft AccessDuckDBSupabaseStripeHubSpotShopifyGoogle AdsGoogle Analytics 4Google Search ConsoleShipStationiTickFile SystemCSV FolderParquet FolderExcel FolderSQLite FolderJSONL FolderMulti-record CSV

Nova FAQ

Does Nova make up tables or columns?

No. Nova writes against your actual columns, types and keys, so it can’t invent a column that isn’t there. Run Schema Intelligence once and it goes further — learning enum values, relationships and business context — which eliminates the wrong JOINs and guessed columns that generic text-to-SQL tools produce.

What is Schema Intelligence — do I have to run it?

Schema Intelligence is an optional, one-time analysis that profiles your database through the agent — one optimized call per table captures distinct counts, NULL rates, enums, value distributions, ranges and sample values, then a cross-table pass writes descriptions, discovers implicit relationships, and labels business domains. Nova works without it, but running it once teaches Nova your structure and context so its SQL is noticeably more accurate. It’s incremental (later runs only re-analyze tables that changed), read-only, and PII-aware.

Can non-technical teammates use Nova?

Yes — that’s the point. Nova isn’t limited to database admins. A teammate signs up with an email address on your company domain, appears in your user list, and then the account creator or an administrator switches on Nova access for them. Non-technical teammates get Concierge Mode: they ask in plain English and get answers, charts and saved reports without writing SQL or knowing the schema. Everything stays read-only and governed, so you decide exactly who can ask.

What is Concierge Mode?

Concierge Mode is how Nova works for people who don’t write SQL. Answers come back as tables and charts instead of code, Nova runs the query itself rather than handing over something to run, and anything worth keeping becomes a report Nova saves AND shares itself — the person never saves a query or clicks share; it lands in their Excel or Google Sheets add-on, with adjustable filters, and in any teammate’s add-on they named. Nova looks after those reports too — renaming, updating and tidying up, always with the person’s approval, and never editing a report a colleague owns. Anyone with the Member role and Nova access is in Concierge Mode automatically; creators and administrators can switch into it from the Nova toolbar.

How is Nova priced?

Nova is included on the Business and Enterprise plans, each with a monthly allowance of Nova credits. Beyond that allowance it’s pay-as-you-go — you only pay for the analysis you actually run, billed on usage like the rest of Query Streams, with no per-seat fees. New accounts get a 30-day free trial on signup with no credit card.

Is my data safe? Can Nova change anything?

Nova runs through the same outbound-only Network Agent as the rest of Query Streams, with a hardcoded read-only validator at the agent — only SELECT, WITH and EXPLAIN run. It can’t insert, update, delete, drop or alter. Your credentials and data never leave your network, and Schema Intelligence profiling excludes PII like passwords, SSNs and keys from sampling.

Can Nova write my scheduled reports, not just answer questions?

Yes. With Alerts & Reports, Nova narrates the result on a schedule and delivers it to Slack, Discord, Google Chat, Telegram or email — no dashboard to open. The report’s own query is only the starting point: Nova can run further queries against related data to explain why a number moved before it writes. If narration ever fails, the plain figures still ship on time — the AI layer never blocks delivery. Report narration is available on Business plans and above.

Meet your data analyst.

Ask a question in plain English and watch Nova read your schema, write the SQL, run it read-only, and chart the answer — then save it for the whole team.

On Business & Enterprise · monthly Nova credits, then pay-as-you-go · 30-day trial