Captures What Actually Runs
Ingest the live SQL workload from PostgreSQL, MySQL, and Trino via webhooks or lightweight pollers. No proxy in front of your traffic, no SDK in your application.
AI SQL Performance & Query Optimization
Find what's slowing your database. Fix it with AI.
QueryInsights is an AI-powered SQL performance tool. It watches your live PostgreSQL, MySQL, and Trino workload, surfaces the slow queries hurting database performance, and turns every pattern into actionable query rewrites and indexing advice — automatically.
Works with PostgreSQL, MySQL, and Trino. No proxy. No code changes.
Why QueryInsights
Database performance is a needle in a haystack. We bring a magnet.
Query optimization shouldn't mean staring at execution plans for hours. QueryInsights does the slow-query analysis for you and hands back the fix.
Without QueryInsights
Your database is slow.
You know it. But you don't know which query, on which table, in which pattern — and dashboards full of metrics don't tell you what to actually change.
Slow queries hide in noise.
The same query runs a thousand ways. Without normalization you can't tell which patterns truly drive load, so slow-query analysis turns into endless log scrolling.
EXPLAIN only goes so far.
Reading query plans one statement at a time is slow, and generic SQL tuning advice ignores your real PostgreSQL, MySQL, or Trino schema. You end up rewriting queries by hand and hoping it helps.
With QueryInsights
The slowest queries in your workload land on your screen, with the fix already written.
- See your slowest query patterns, ranked by real impact.
- Get a ready-to-ship query rewrite for each one.
- Know which indexes and schema changes speed up the whole workload.
What it does
From raw queries to actionable advice
QueryInsights closes the loop between “something is slow” and “here is exactly what to change” — automatically, for every pattern in your workload.
Sees the Patterns, Not the Noise
Thousands of queries collapse into a handful of patterns by replacing literals with placeholders. You see what's truly heavy — not duplicates dressed up as different queries.
Rewrites Slow Queries
Every slow query pattern gets a focused AI query-optimization review grounded in your real table definitions — predicate ordering, join shape, engine-specific gotchas, written so an engineer can ship it.
Recommends Indexes & Schema
Periodic AI analysis across your top tables and access patterns surfaces index recommendations and schema changes that improve database performance broadly — not just for one query in isolation.
Ranks Slow Queries by Impact
Query patterns are ranked by frequency and cost, so the slow queries at the top are the ones worth optimizing first. No more guessing where your database performance is going.
Cuts Compute & Database Cost
Slow queries burn CPU and scan extra data. By fixing your heaviest patterns first, QueryInsights lowers database resource usage and helps reduce query compute and cloud database costs.
How it works
Four quiet steps. Loud results.
QueryInsights sits beside your PostgreSQL, MySQL, or Trino database, learns from the queries that actually run, and turns that into specific query-optimization advice — so you stop guessing where to look.
01
Ingest
Pick up live queries via webhooks from your engines or via lightweight pollers that read query statistics directly. Nothing sits in your traffic path.
02
Normalize
Strip out the literals so a thousand variants of the same query collapse into a single pattern. You see real workload shape, not noisy duplicates.
03
Understand
Each pattern is paired with the real table definitions it touches, so the AI has the context it needs to reason about your database, not a generic one.
04
Recommend
Get specific, ready-to-ship rewrites for individual queries — and broader schema and index advice for the whole workload, updated as it evolves.
The flow
Sits beside your stack. Stays out of the way.
QueryInsights is a side-car for your databases — it observes, learns, and serves up advice. Nothing in the request path. Nothing for your application to integrate.
What you get
One pattern. One specific fix.
Every top query in your workload gets its own AI review — grounded in your real schema, written like a teammate would write it.
TrinoHigh impact
12,403executions in 24hThe pattern
SELECT *
FROM orders o
JOIN line_items l ON l.order_id = o.id
WHERE o.created_at > ?
ORDER BY o.id
LIMIT ?Wide SELECT *, late filter, unbounded top-N sort over a join on a hot table.
The recommendation
SELECT o.id, o.created_at, l.sku, l.qty
FROM orders o
JOIN line_items l ON l.order_id = o.id
WHERE o.created_at > ?
AND o.id > ? -- keyset pagination
ORDER BY o.id
LIMIT ?- Project only the columns this caller uses.
- Keyset pagination removes the unbounded sort.
- Predicate ordering pushes the time filter first.
FAQ
SQL performance questions, answered.
What QueryInsights does, which databases it supports, and how it finds and fixes slow queries.
What is QueryInsights?
QueryInsights is an AI-powered SQL performance and query optimization tool. It watches your live database workload, identifies the slow queries and query patterns that hurt performance, and suggests specific rewrites and schema changes — so your team fixes the highest-impact problems first.
Which databases and query engines does QueryInsights support?
QueryInsights works with PostgreSQL, MySQL, and Trino, and is built to extend to other SQL engines. Whether you run a transactional Postgres or MySQL database or a distributed Trino query engine, it captures the real workload and analyzes it the same way.
Why is my SQL query slow?
A SQL query is usually slow because it scans more data than it needs, filters too late, joins inefficiently, or is missing an index. QueryInsights acts as a query profiler and database advisor: it pinpoints which of your query patterns are slow and why, then recommends the specific change to fix it — instead of leaving you to guess from a query plan.
How does QueryInsights find slow queries?
It captures the queries that actually run, normalizes them into patterns by stripping out literal values, and ranks those patterns by frequency and impact. Instead of scrolling through thousands of individual statements, you see the handful of slow query patterns that account for most of your database load.
How do I speed up a slow SQL query?
Speeding up a slow query usually means scanning less data, filtering earlier, fixing the join or projection, or adding the right index. QueryInsights does this analysis for you: it captures the query that's taking too long, grounds an AI review in your real schema, and returns a ready-to-ship rewrite plus any index that improves query response time.
What kind of query optimization recommendations does it generate?
Two complementary kinds. Per-query rewrites show how a specific slow query can be written better — predicate ordering, join shape, projection scope, and engine-specific tuning. Workload-level advice recommends indexes, schema, and storage-layout changes that speed up your entire access pattern, not just one query.
Is QueryInsights a replacement for EXPLAIN or query plans?
No — it complements them. EXPLAIN and execution plans tell you how one query runs right now; QueryInsights tells you which queries across your whole workload are worth optimizing and hands you a concrete fix, grounded in your real schema, so you spend less time reading query plans by hand.
Can QueryInsights reduce my database costs?
Often, indirectly. Slow queries burn CPU, scan extra data, and tie up resources. On cloud and managed databases where you pay for query compute or scanned data, optimizing your heaviest query patterns lowers database resource usage and can reduce compute costs. QueryInsights ranks patterns by impact so you cut the most expensive ones first.
How does QueryInsights capture my queries?
Two non-invasive paths: webhook-based capture from engines that emit query events, and lightweight pollers that read query statistics directly from the database. There is no proxy in front of your traffic and no SDK in your application, so it can never affect latency or availability.
Do I need to change my application code?
No. QueryInsights observes your database performance from the side. There are no driver changes, no SDKs, and no code changes required to start getting slow-query analysis and optimization recommendations.
Is QueryInsights available today?
QueryInsights is in early access. Reach out to be notified when it opens up more broadly and to get help connecting your PostgreSQL, MySQL, or Trino workload.
Early access
Want to see what's slowing your database?
QueryInsights is in early access. Tell us a little about your workload and we'll be in touch.
Or email us at hello@queryinsights.dev