Skip to main content
While Basedash excels at creating charts through natural language, you can also write custom SQL queries when you need more control or complex analysis.

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

Need help writing SQL? Our AI can:
  • Generate queries from natural language
  • Explain complex queries
  • Suggest optimizations
  • Fix syntax errors
Just describe what you want to query, and the AI will help write the SQL.

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
  • Save frequently used queries

Working with results

Visualization

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

Cached results

  • Query results are cached for 24 hours
  • View cache status for each query
  • Force refresh when needed
  • Configure caching per query

Advanced features

Variables

Use variables in your queries:
SELECT *
FROM orders
WHERE date >= {{start_date}}
  AND date <= {{end_date}}

Scheduled queries

  • Set up recurring queries
  • Export results automatically
  • Monitor query performance
  • Get alerts on failures

Security

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