Skip to main content

Query Your Data

Learn how to write and execute SQL queries in nao.

Writing Queries​

To write a query:

  1. Open a new SQL worksheet or use the query editor
  2. Write your SQL query
  3. Use the auto-complete feature for table and column names
  4. Format your query using the format button

Executing Queries​

To run a query:

  1. Click the "Run" button or press Cmd/Ctrl + Enter
  2. View results in the results panel
  3. Export results if needed
  4. Save queries for later use

Query Features​

nao provides several features to help you write better queries:

  • Syntax highlighting
  • Auto-completion for tables and columns
  • Query formatting
  • Error highlighting
  • Query history
  • Saved queries

Best Practices​

  • Use the auto-complete feature to avoid typos
  • Format your queries for better readability
  • Save frequently used queries
  • Use the query history to reference past queries
tip

Use Cmd/Ctrl + Space to trigger auto-completion for tables and columns.

info

Queries are executed in read-only mode by default to prevent accidental data modifications.