SQL when you need it
full control in Mora

Write raw SQL against any connected data source, with AI-assisted autocomplete, schema exploration, and instant visualization. For power users who want full control without leaving Mora.

Three steps

no engineers required

Numerical — CeGJl89Y7cNTGiv2rSzc

01

Select a source

Select a source

Choose which data source to query: your warehouse, a direct database connection, or Mora’s unified data layer that spans all connected sources.

Choose which data source to query: your warehouse, a direct database connection, or Mora’s unified data layer that spans all connected sources.

Numerical — CeGJl89Y7cNTGiv2rSzc

02

Numerical — CeGJl89Y7cNTGiv2rSzc

02

Write or generate

Write or generate

Write SQL manually with AI-powered autocomplete, or describe what you want in plain English and Mora generates the query for you. Edit and refine as needed.

Write SQL manually with AI-powered autocomplete, or describe what you want in plain English and Mora generates the query for you. Edit and refine as needed.

Numerical — CeGJl89Y7cNTGiv2rSzc

03

Visualize and share

Results render as tables by default. One click converts them to any chart type. Pin queries to dashboards, schedule them to run on a cadence, or share them with your team.

Numerical — CeGJl89Y7cNTGiv2rSzc

03

Visualize and share

Results render as tables by default. One click converts them to any chart type. Pin queries to dashboards, schedule them to run on a cadence, or share them with your team.

Numerical — CeGJl89Y7cNTGiv2rSzc

03

Visualize and share

Results render as tables by default. One click converts them to any chart type. Pin queries to dashboards, schedule them to run on a cadence, or share them with your team.

Everything you need
in one single platform

AI-assisted autocomplete

Mora suggests table names, column names, joins, and common patterns as you type, context-aware and trained on your actual schema.

Natural language to SQL

Start with a description, get a query. “Show me all accounts that downgraded in Q4 with more than 5 support tickets” generates the SQL instantly. Edit the output or run it as-is.

Cross-source queries

Write a single query that joins data from Stripe, Salesforce, and your warehouse. Mora handles the federation, so you write standard SQL.

Schema explorer

Browse every connected source’s schema in the sidebar: tables, columns, data types, relationships, and sample values. No switching to a separate tool.

Query versioning

Every query is saved with full version history. Roll back to any previous version, fork queries, and track changes over time.

Parameterized queries

Add variables to your queries and reuse them as templates. “Show churn for {{segment}} in {{date_range}}” becomes a reusable tool anyone on your team can run.

Built for the moments
that drive revenue

Ad-hoc deep dives

The conversational interface got you 80% of the way. Now drop into SQL to fine-tune the query, add custom logic, or run a more complex analysis.

Data validation

Your dashboard shows a number that looks off. Open the SQL editor, inspect the underlying query, and trace the data to its source.

Complex joins and transformations

Multi-step queries that require CTEs, window functions, or custom aggregations: write them directly with full AI assistance.

Reusable reporting

Build parameterized queries that your team runs weekly. “Monthly churn report by segment” becomes a one-click operation.

Here’s what
you should know

Here’s what
you should know

Supported SQL dialects

Auto-detects PostgreSQL, Snowflake SQL, BigQuery Standard SQL, ClickHouse SQL, MySQL, and Redshift

AI autocomplete model

Context-aware, trained on your schema and query history

Max result set

100K rows in the UI; full result sets available via export (CSV, JSON)

Execution timeout

Configurable per source; defaults to 60 seconds for interactive queries

Keyboard shortcuts

Full set of editor shortcuts: run query, format SQL, toggle autocomplete, navigate history

Access controls

Query-level sharing permissions; role-based access to data sources and schemas

Full SQL power

With AI doing the heavy lifting.