🎉 You're in Demo Mode!
Try queries on sample data.
Sign up free to connect your own database.
Worksheet
Free
Query result
SQL history
Run a query to see results
Library
Community
Recently Viewed
🔍 Data Quality
Find Duplicate Records
Identify duplicate rows based on specific columns. Edit {table_name} and {column1, column2} to match your schema.
📊 Analytics
Create Pivot Table
Transform rows into columns for cross-tabulation analysis. Perfect for summarizing data by categories.
⚡ Performance
Index Usage Analysis
Analyze index usage statistics to identify unused or missing indexes that affect query performance.
📈 Window Functions
Running Totals & Cumulative Sum
Calculate running totals, cumulative sums, and moving averages using window functions.
📅 Time Series
Find Gaps in Dates
Identify missing dates or gaps in sequential date ranges for time series analysis.
🏆 Ranking
Top N Records per Group
Get the top N records within each group using ROW_NUMBER() or RANK() window functions.
💾 Storage
Table Size & Row Counts
Analyze database storage usage, table sizes, and row counts for capacity planning.
📆 Comparison
Year-over-Year Comparison
Compare metrics across different time periods with percentage change calculations.
🐢 Diagnostics
Slow Query Detection
Identify long-running queries and performance bottlenecks in your database.