Getting Started

Welcome to QueryLens! This guide will help you get up and running quickly.

Quick Start

Follow these steps to analyze your first query:

1. Sign up for a free account at querylens.tech/signup
2. Navigate to the Query Analyzer dashboard
3. Paste your SQL query into the editor
4. Click "Analyze" to get instant insights

Example Query

SELECT u.name, COUNT(o.id) as orders
FROM users u
LEFT JOIN orders o ON u.id = o.user_id
GROUP BY u.id
HAVING COUNT(o.id) > 5;

Query Explanation

QueryLens breaks down your SQL queries into understandable components:

• Clause Analysis - Understand what each SELECT, WHERE, JOIN clause does
• Data Flow - Visualize how data moves through your query
• Plain English - Get human-readable explanations
• Complexity Score - Understand query complexity at a glance

Optimization Hints

Our AI analyzes your queries and provides actionable optimization suggestions:

• Index Recommendations - Identify missing indexes
• Join Optimization - Improve join efficiency
• Query Rewriting - Get optimized query alternatives
• Performance Estimates - Understand expected improvements

Visualization

Transform your query results into compelling visual stories:

• Auto-Generated Charts - Automatic chart type selection
• Narrative Insights - AI-generated data stories
• Export Options - PNG, SVG, and PDF exports
• Embed Codes - Share visualizations anywhere

API Reference

Integrate QueryLens into your workflow with our REST API:

Authentication

curl -X POST https://api.querylens.tech/v1/analyze \
  -H "Authorization: Bearer YOUR_API_KEY" \
  -H "Content-Type: application/json" \
  -d '{"query": "SELECT * FROM users"}'

Response Format

{
  "explanation": "This query selects all columns...",
  "optimizations": [...],
  "complexity_score": 2
}