Query Engine

Documentation Index

Fetch the complete documentation index at: https://docs.plumi.ai/llms.txt

Use this file to discover all available pages before exploring further.

​

Overview

​

Features

​

SQL Editor

• Syntax highlighting for SQL
• Auto-completion for tables, columns, and functions
• Schema explorer to browse your database structure
• Query history to revisit previous queries

​

Query Execution

• Execute queries against any connected database
• View results in a responsive data grid
• Export results to CSV or JSON
• Pin frequently used queries

​

Schema Explorer

• View all tables and columns
• See column types and constraints
• Preview sample data from tables
• Search across your schema

​

Using the Query Engine

​

Writing Queries

1. Select your database from the dropdown
2. Write your SQL in the editor
3. Press Cmd/Ctrl + Enter to execute
4. View results in the grid below

SELECT
  customer_name,
  SUM(order_total) as total_revenue
FROM orders
JOIN customers ON orders.customer_id = customers.id
WHERE order_date >= '2024-01-01'
GROUP BY customer_name
ORDER BY total_revenue DESC
LIMIT 10;

​

Keyboard Shortcuts

​

AI Assistance

• Get suggestions for query optimization
• Explain complex queries
• Generate queries from natural language