Query Editor

The Query Editor is where you'll spend most of your time in DBStudio. It's a full-featured SQL development environment built for productivity.

Core Features

SQL Editing

• Syntax highlighting for MySQL, PostgreSQL, and SQLite.
• Auto-completion powered by your actual schema (table names, column names, keywords).
• Multiple tabs for working on several queries simultaneously.
• Error toasts for syntax issues.

Query Execution

Run queries with the Run button. Results appear instantly in a scrollable, sortable data grid.

SELECT 
  customers.name,
  COUNT(orders.id) AS order_count,
  SUM(orders.total) AS revenue
FROM customers
JOIN orders ON orders.customer_id = customers.id
GROUP BY customers.id
ORDER BY revenue DESC
LIMIT 10;

Query History

Every query you run is saved automatically. Access your history from the sidebar to:

• Re-run previous queries.
• Copy SQL to clipboard.
• Compare results over time.

Data Export

Export your query results in multiple formats:

Click the Export dropdown after running a query to download results instantly.

AI Integration

The Query Editor integrates deeply with the AI Copilot:

• Explain: Get a plain-English breakdown of complex queries.
• Optimize: Receive suggestions for indexes and query rewrites.
• Natural Language: Type in English and generate SQL automatically.