PromptDB
Ask a database in plain English. The agent reads the schema, writes a read-only query, self-corrects, runs it, and explains the answer.
69.3% · Spider dev
read-only · self-correcting
try live →
data source
Read-only queries against the FireScope wildfire database — a real project, served read-only on the demo key.
model
A worked example on the FireScope wildfire database. Edit the question above (or click a chip) and hit run to query live.
read schema
write SQL
guardrail
execute
answer
generated SQLREAD-ONLY
SELECT DATE_TRUNC('month', published_at)::DATE AS month, COUNT(*) AS count
FROM news_articles
WHERE published_at IS NOT NULL
GROUP BY DATE_TRUNC('month', published_at)
ORDER BY month DESC
LIMIT 6result · 4 rows
| month | count |
|---|---|
| 2026-06-01 | 17 |
| 2026-05-01 | 156 |
| 2026-04-01 | 58 |
| 2026-03-01 | 14 |
May 2026 saw the most wildfire coverage with 156 articles, ahead of April (58), June (17), and March (14). The agent read the schema, wrote this read-only PostgreSQL query, ran it, and explained the result.
cost $0.00310latency 2.4sdemo · — free left