01
Query score + findings
Every query gets a 0–100 score with severity-tagged findings. High-severity issues (full scans, unconstrained joins) sink the score fastest so you know where to focus.
A DB query optimizer with an EXPLAIN visualizer, a heuristic query scorer, and configurable slow-query alerting. Paste a query, see the plan, get concrete recommendations — then wire duration thresholds to Slack and Suite Pulse.
A query scorer, not just an EXPLAIN viewer. Every query gets a 0–100 score with anti-pattern detection: SELECT *, full scans, function-on-column, NOT IN, unconstrained joins, unbounded sorts.
EXPLAIN ANALYZE
SELECT * FROM events WHERE user_id = $1 AND ts > now() - '7d'
Standard Lens is a DB query optimizer with an EXPLAIN plan visualizer and a heuristic query scorer. Paste a SQL query and the analyzer flags anti-patterns — SELECT *, full table scans, functions on indexed columns, NOT IN, unconstrained joins, unbounded sorts — and emits a 0–100 score plus concrete recommendations. Save queries to your library with tags and pin the hot ones. A configurable slow-query detector records anything over your threshold and alerts via Slack or Suite Pulse. Deep-link into Standard Vault for the connection string and Standard Hook for webhook payload regex.
Every query gets a 0–100 score with severity-tagged findings. High-severity issues (full scans, unconstrained joins) sink the score fastest so you know where to focus.
The plan tree is rendered as a nested list with node type, relation, row estimate, and cost — so you can see Seq Scan vs Index Scan at a glance.
Set a duration threshold per database. Anything over it is captured with the SQL text, duration, and source, then surfaced on the slow-queries dashboard.
Route slow-query and missed-cron alerts to a Slack channel or Suite Pulse. Thresholds are per-database so you can tune noise vs signal.
Save queries with tags and pin the hot ones. Re-run the analyzer after a schema migration to confirm the score improved before deploying.
Deep-link into Standard Vault for the database connection string (agent-reference mode), and Standard Hook to test webhook payload regex against captured events.
Start free. Upgrade when you outgrow limits or want to remove the powered-by badge.
100 queries/day + 7-day slow history
unlimited queries + 30-day history
unlimited + full history + Slack alerts
Three focused products, one portfolio. Each app is built to spread your brand while solving one job extremely well.
Open Dashboard| Feature | Spreadsheets | Generic SaaS | Market Standard Market Standard |
|---|---|---|---|
| Purpose-built for the workflow | No | Partial | Yes |
| Free tier with no credit card | — | Sometimes | Yes |
| Open schema (Postgres + Drizzle) | No | No | Yes |
| Viral powered-by badge on free tier | No | No | Yes |
| Cross-sells into the rest of the suite | No | No | Yes |
| Self-hostable source-available code | No | No | Yes |
Everything you need to know before signing up.