- Initial setup: Connect a datasource, write your first query, and try the AI assistant. ~10 minutes
- Personalize your workspace: Sync app data, generate datasource knowledge, invite teammates, and build a dashboard. ~25 minutes
- Make Mora your team’s data analyst: Migrate dashboards, shape data with no-code transformations, and operationalize sharing. ~1 hour
Initial setup
Time required: ~10 minutes. Mirrors the Get started checklist in the bottom-left of the sidebar. After signing up, you’ll be taken through a short onboarding flow that collects your profile, sets up your workspace, and starts a 14-day Pro trial. Once that’s done, you’ll land in the app and can pick up here.All plans include a 14-day free trial. Card details are collected upfront and the subscription auto-converts after the trial. Manage or cancel any time from Settings → Billing.
1. Connect your first datasource
A datasource is a direct connection to your SQL database or warehouse. Mora supports seven types out of the box.- Open Settings → Datasources and click Add datasource.
- Pick the type and give the datasource a name.
- Fill in the credentials (see the cheat sheet below).
- Click Test connection to verify Mora can reach your database.
- Click Add datasource.
PostgreSQL, MySQL, Redshift
PostgreSQL, MySQL, Redshift
Host, port, database, user, password. Optional SSL toggle for encrypted connections.
BigQuery
BigQuery
A service account JSON with read access to the datasets you want to query.
ClickHouse
ClickHouse
URL, username, password, and an optional database name.
Snowflake
Snowflake
Account, warehouse, database, schema, username, password, and an optional role.
Databricks
Databricks
Host, HTTP path, access token, and catalog.
2. Write your first dataset
A dataset is a saved SQL query tied to a datasource. Datasets are the foundation of every chart on every dashboard.- In the sidebar, expand Datasets and click the + button (or use the empty-state Create a dataset card).
- Pick the datasource you just connected.
-
Write a query in the SQL editor, try something simple to start:
- Click Run (or press Cmd+Enter) to preview results in the bottom pane.
- Click Save in the top-right (or press Cmd+S) to save and publish.
New datasets are private by default, only you can see them. They appear under the Drafts section in the sidebar. Toggle Share with team from the dataset’s overflow menu when you’re ready to publish org-wide.
3. Try the AI assistant
The AI assistant lives in the right-hand chat panel. It can write SQL, debug queries, build charts, manage dashboards, and answer questions about your data.- On the home page, a dataset page, or a dashboard page, press Cmd+/ (or click the right-pane toggle in the header).
-
Pick a mode at the bottom of the panel:
- Auto: the AI decides which tools to use. Best default.
- SQL: focused on SQL editing and schema exploration.
- Dashboard: focused on dashboard, chart, and filter management.
- Ask: read-only. The AI can answer and run queries, but cannot create, update, or delete anything.
-
Type a question, for example:
“Show me a line chart of total orders by date for the last 90 days.”
Learn more about the AI
See everything the assistant can do, including the four chat modes and tips for getting better results.
Personalize your workspace
Time required: ~25 minutes. These steps round out the in-app Get started checklist and make the workspace feel like home.Sync data from third-party apps
Connections sync data from apps like Stripe, HubSpot, and Salesforce into a schema inside one of your existing datasources. Once synced, the data shows up in your catalog and can be queried like any other table.- Open Settings → Connections and click Add connection.
- Search for the app or pick one from the popular list.
- Choose the destination datasource the data will sync into. (If you haven’t connected a warehouse yet, do that first in Settings → Datasources.)
- Authenticate or paste an API key, depending on the connector.
- Pick a target schema (e.g.
stripe,hubspot).
| Application | Auth method |
|---|---|
| PostHog | API key |
| Stripe | API key |
| Salesforce | OAuth |
| HubSpot | OAuth |
| Attio | OAuth |
| Google Sheets | Service account |
| Facebook Ads | OAuth |
| Other integrations | Varies |
Generate datasource knowledge
Mora can read your catalog and write a narrative description of what each schema and table represents. This knowledge is fed into the AI assistant so it picks the right tables for your questions.- Open Settings → Datasources and click into a datasource.
- Find the Knowledge section and click Explore.
- Mora’s agent inspects the catalog and generates a knowledge document. You can edit or extend it later.
Invite your teammates
- Open Settings → Members.
- Enter a teammate’s email and click Invite.
Members see all shared datasets and dashboards in your organization. Anything kept as a private draft stays with its owner.
Build your first dashboard
A dashboard (sidebar label: Dashboards) is a grid of charts. Each chart is linked to a dataset.- In the sidebar, expand Dashboards and click the + button.
- Click Add block in the top toolbar, an empty Table block appears on the grid.
- Click the block to open the side pane:
- Data tab, pick a dataset.
- Visualization tab, choose Table, Graph (line, area, bar, scatter, or pie), or Stats. Configure axes, columns, and aggregations.
- Drag the block to reposition; resize from the corners.
- Click Add block again to layer in more charts.
Add dashboard-level filters
Dashboard filters apply to every chart on the dashboard at once, useful for date ranges, customer segments, or any column shared across datasets.- On a dashboard, click the Filters button in the top toolbar.
- Pick the columns to filter on (Mora finds shared columns across the datasets in use).
- Set a value, pills appear in the toolbar that you can drag to reorder.
Make Mora your team’s data analyst
Time required: ~1 hour. Do this when you’re ready to migrate from your existing analytics tools and roll Mora out across the team.Migrate dashboards from your previous analytics tool
Mora doesn’t import dashboards directly, but the AI makes recreation fast.- Copy the SQL from your existing tool (Looker, Metabase, Mode, Hex, etc.).
- Open a new dataset in Mora, paste the SQL, and ask the AI: “Convert this Looker SQL to Snowflake dialect.”
- Run the query, save the dataset.
- Add the dataset as a block on a dashboard and configure the visualization to match the original.
Shape your data with no-code transformations
Transformations are a click-and-drag layer that runs on top of your saved dataset results, no SQL rewriting required.- Group rows by one or more columns.
- Aggregate with sum, average, count, median, min, max, percentage, and more.
- Filter with equals, contains, ranges, relative dates, booleans,
IN, etc. - Sort by any column.
- Hide columns from the visualization without removing them from the underlying data.
Transformations
Group, aggregate, filter, sort, and hide columns without writing more SQL.
Chart transformations
Customize a chart’s shape without touching the underlying SQL.
Share, favorite, and duplicate
- Datasets: toggle from Draft (private) to shared via the dataset overflow menu. Shared datasets show up under the Datasets section in everyone’s sidebar.
- Dashboards: favorite from the dashboard header to keep them at the top of your sidebar; duplicate to fork a copy you can edit independently.
Org admin essentials
- Roles: promote teammates to admin or owner from Settings → Members.
- Billing: the Billing item in the settings sidebar (visible to owners and admins) opens the Stripe Customer Portal in a new tab. Manage payment methods, change plans, view invoices, and cancel from there.
- Datasource credentials: rotate or update from Settings → Datasources → [datasource].
Account & organization
Profile, organization settings, members, and billing in one place.
Power features
A few shortcuts and tools that pay off after the first day.| Action | Shortcut |
|---|---|
| Open the command palette | Cmd+K |
| Toggle the sidebar | Cmd+B |
| Toggle the AI chat | Cmd+/ |
| Run dataset query | Cmd+Enter |
| Save dataset | Cmd+S |
| Cycle AI chat mode | Shift+Tab |
- G then H: home
- G then B: pick a dashboard
- G then D: pick a dataset
- G then O: pick a datasource
- G then S: settings
All keyboard shortcuts
The full list of shortcuts and command palette actions.
Common chat prompts
The AI is most useful when it’s part of your daily routine. A few categories of prompts to get you started:Finding data
- “Which tables have user-level events?”
- “Show me the schema of the
orderstable.” - “Are there any tables with revenue data?”
- “Find columns related to
customer_idacross the catalog.”
Building charts
- “Plot weekly signups as a line chart.”
- “Add a stats block for total ARR with a week-over-week delta.”
- “Create a bar chart of revenue grouped by plan, sorted descending.”
- “Build a dashboard with the three most useful charts for tracking activation.”
Writing & fixing SQL
- “Optimize this query.”
- “Why is this query failing?” (Or click Fix with AI when the editor surfaces an error.)
- “Convert this Looker SQL to Snowflake dialect.”
- “Add a 30-day rolling average to this query.”
Reporting & summaries
- “Summarize this dashboard for our weekly review.”
- “What changed week over week on this dashboard?”
- “Which metrics on this dashboard look unusual right now?”
Everything the AI can do
Read the full list of supported AI actions, from SQL editing to dashboard layout.
Getting help
If you get stuck, we’re happy to help.- In-app AI: open the chat (Cmd+/) and ask. The assistant can answer most questions about your workspace, your data, and how to use Mora.
- Email: support@mora.com.
Core concepts
Once you’re set up, read the concepts guide to understand how datasources, datasets, transformations, charts, and dashboards fit together.
