Query view showing the database query interface with SQL editor and results Xata’s built-in query interface provides a comprehensive environment to explore your data. Run SQL statements, generating SQL with natural language, view and export your results and save your queries for later use.

​
Run Statements

Execute SQL queries directly in the browser with syntax highlighting and auto-completion.
  • Autocomplete makes it easy to create queries without intimate schema knowledge
  • Run multiple statements seperately or at once
  • Select from mutliple databases in the branch instance to run queries against
  • Perform not just exploratory statements, but DDL statements as well
  • Every query created can be saved for re-use

​
Generate SQL

Use AI-powered SQL generation to create queries from natural language descriptions. Simply ask your data a question to start exploring. SQL generation interface showing natural language to SQL conversion

​
View Results

View your query results directly in Xata
  • View query results in a clean table format
  • If multiple statements are run, results are tabbed
  • Quickly export your results to a CSV format