Console

The Console is Mako’s query editor. It connects to any database you’ve added and lets you write, execute, and save queries — with AI assistance built in.

Features

• Multi-database: One editor for PostgreSQL, MongoDB, BigQuery, MySQL, ClickHouse, SQLite, and more
• AI-assisted: Ask questions in natural language, get working queries placed in your editor
• Saved queries: Consoles persist in your workspace, organized in folders
• Shareable: Share consoles with your team via the workspace
• API access: Execute saved consoles programmatically via REST API
• Scheduled queries: Run saved consoles on cron schedules and inspect run history

Working with Consoles

Creating a Console

Click the + button in the sidebar to create a new console. Select a database connection and start writing.

Running Queries

Hit Cmd+Enter (Mac) or Ctrl+Enter to execute. Results appear in a table below the editor.

Using AI

Open the chat panel and describe what you want. The agent will:

1. Inspect your database schema
2. Write the query
3. Execute it to verify it works
4. Place it in your console

Organizing

Consoles can be organized into folders. Use the sidebar tree to drag and arrange.

Scheduling Saved Consoles

Workspace admins can schedule a saved console to run automatically from the console header. Scheduled consoles use five-field cron expressions plus an IANA timezone, for example 0 0 * * * with UTC for a daily midnight run.

When a console is scheduled, Mako stores the next run time and executes it through Inngest. The schedule panel shows the latest run status, duration, row count, consecutive failures, and recent run history. Admins can also trigger a scheduled console manually with Run now. You can attach notifications to a schedule (email, webhook, or Slack) — see Notifications.

Console API

Saved consoles can be executed programmatically. This is useful for building dashboards, automations, or integrations on top of your queries.

Authentication

Create an API key in Workspace settings → API Keys. The same page shows your Workspace ID with a copy button — substitute it for WORKSPACE_ID in the examples below. Include the key in requests:

Authorization: Bearer revops_YOUR_API_KEY

Endpoints

Method	Endpoint	Description
GET	/api/workspaces/:wid/consoles/list	List all consoles
GET	/api/workspaces/:wid/consoles/:id/details	Get console details + code
POST	/api/workspaces/:wid/consoles/:id/execute	Execute a console
PUT	/api/workspaces/:wid/consoles/:id/schedule	Create or update a schedule (admin only)
DELETE	/api/workspaces/:wid/consoles/:id/schedule	Remove a schedule (admin only)
POST	/api/workspaces/:wid/consoles/:id/schedule/run	Trigger a scheduled console now (admin only)
GET	/api/workspaces/:wid/consoles/:id/schedule/runs	List scheduled run history (admin only)
GET	/api/workspaces/:wid/scheduled-queries	List scheduled consoles in the workspace (admin only)

Example

# Execute a saved console
curl -X POST \
  -H "Authorization: Bearer revops_YOUR_API_KEY" \
  https://app.mako.ai/api/workspaces/WORKSPACE_ID/consoles/CONSOLE_ID/execute

Response:

{
  "success": true,
  "results": [
    { "name": "Alice", "revenue": 12500 },
    { "name": "Bob", "revenue": 8900 }
  ],
  "metadata": {
    "rowCount": 2,
    "executionTimeMs": 145
  }
}