SQL editor

​

The SQL editor

​

Features

• Syntax highlighting
• Auto-completion
• Schema browser
• Query history
• Result previews
• Performance metrics

​

Writing queries

​

Basic query structure

SELECT column1, column2
FROM your_table
WHERE condition
GROUP BY column1
ORDER BY column2 DESC
LIMIT 100

​

AI query assistant

• Generate queries from natural language
• Explain complex queries
• Suggest optimizations
• Fix syntax errors

​

Query best practices

​

Performance

• Use appropriate LIMIT clauses
• Avoid SELECT *
• Index important columns
• Use efficient joins

​

Organization

• Format queries for readability
• Add comments for complex logic
• Use CTEs for better structure

​

Working with results

​

Visualization

• Convert results to charts
• Export to CSV/Excel
• Share query results
• Save as dashboard components

​

Result freshness

​

Advanced features

​

Variables

SELECT *
FROM orders
WHERE date >= {{start_date}}
  AND date <= {{end_date}}

​

Security

• Read-only access by default
• Query history logging
• Resource usage limits
• Data access controls

​

FAQ