Every feature, one secure agent.

One SQL statement across separate databases

Your orders are in MySQL, your customers in PostgreSQL, the targets in a SQL Server box at head office. A federated query reads all three in one ordinary SELECT and hands you a single table — no exports, nothing copied anywhere, and nothing new to open on your firewall.

• Name two or more of the connections you already have — that is all it takes
• Each database does its own share of the work, then the pieces are joined
• Refuses rather than guess — a clear reason, never a quietly wrong total
• Nova drafts the statement for you and explains any refusal in plain words

Included on paid plans

Database → live REST API in ~90 seconds

Turn any saved query into a secure REST endpoint with a personal key per recipient. Share live Postgres, SQL Server & MySQL data without handing out credentials, hosting a gateway, or opening a firewall port.

• A personal API key per recipient — revoke any one anytime
• Permanent, expiring, or self-destruct endpoints
• Rate limits, byte quotas, IP & CORS allowlists
• Read-only at the agent — OpenAPI 3.1, JSON & CSV output

Included on Business & Enterprise

Governed filters, zero code

Expose safe inputs from named variables (e.g. @region) or auto-detected conditions (e.g. WHERE brand = 'Acme'). Recipients change the value — never the SQL — right in the query’s Properties tab.

• Read-only and secure — SQL never exposed
• Auto-detect static conditions and named parameters
• Parallel execution across multiple filter runs

APIs become SQL tables

Query Stripe, HubSpot, Shopify, Google Analytics 4, Search Console, ShipStation & iTick with standard SQL — the Agent syncs each API into a caching layer, so there’s no API code and no ETL pipeline to maintain.

• Write SQL, not API code or scripts
• Pre-built query library with ready-to-use templates
• Share API reports without exposing API keys

Your data tells you when something changed

Write the query once, then let it watch itself. Set a threshold on anything you can express in SQL — stock cover, margin slippage, overdue invoices, a stalled pipeline — and Query Streams checks it on your schedule and speaks up in the tools your team already reads. Reports work the same way, on a weekly or daily cadence, with Nova writing the narrative around the numbers.

• Alerts open and recover on their own — no repeat pings while a problem is still open
• Nova reads the result, then queries further for context before it writes
• Delivered to In-app, Email, Slack, Discord, Google Chat, Telegram or a signed webhook
• Works on every connector — databases and APIs alike, including Free