Documentation
Learn how to use SQL Query Analyzer to optimize your queries and improve database performance.
Getting Started
Quick start guide to analyzing your first SQL query
Analysis Rules
Understanding the 25+ rules that detect SQL issues
SQL Dialects
PostgreSQL, MySQL, SQL Server, Oracle, SQLite, BigQuery, Redshift, and auto-detection
API Reference
API documentation for programmatic access (Premium)
Getting Started
1. Paste Your Query
Navigate to the Analyzer page and paste your SQL query into the editor.
2. Select Dialect (Optional)
Choose your database dialect (PostgreSQL, MySQL, SQL Server, Oracle, SQLite, BigQuery, Redshift) or leave it on auto-detect.
3. Analyze
Click "Analyze Query" or press Ctrl+Enter to get instant results.
4. Review Results
Check your score, review issues by severity, and apply suggested improvements.
Analysis Rules
SELECT * Detection (Medium)
Detects when queries select all columns instead of specifying needed columns.
Why it matters: Selecting unnecessary columns wastes bandwidth and memory.
How to fix: Specify only the columns you need.
Missing WHERE in UPDATE/DELETE (Critical)
Detects UPDATE or DELETE statements without WHERE clauses.
Why it matters: Can accidentally modify or delete all rows in a table.
How to fix: Always include a WHERE clause to specify affected rows.
Function in WHERE Clause (High)
Detects functions applied to columns in WHERE clauses.
Why it matters: Prevents index usage, causing full table scans.
How to fix: Move the function to the comparison value or use functional indexes.
Understanding Your Score
90-100
Excellent
70-89
Good
50-69
Fair
0-49
Poor
Scores are calculated based on the severity and number of issues found. Critical issues deduct 30 points, high severity 20 points, medium 10 points, and low 5 points.
Frequently Asked Questions
Does the analyzer execute my queries?
No. We perform static analysis only. Your queries are never executed on any database.
Which SQL dialects are supported?
We support PostgreSQL, MySQL, SQL Server, Oracle, SQLite, BigQuery, and Redshift with intelligent auto-detection.
How accurate is the analysis?
Our rules are based on industry best practices and common performance patterns. However, some recommendations may not apply to your specific use case.
Can I save my analysis results?
Query history is available in the Professional plan. View pricing.