Add related table data and aggregations with a couple of clicks
Create dashboards
Cross-filtered views with a variety of visualization types including charts, maps, tables, and more
AI Assistant
Create dashboards, analyse and augment data using natural language prompts under strict data access rules. Supports MCP tools and a variety of proprietary and open source models
SQL Editor
Fast and relevant autocomplete suggestions to create complex queries and views. JSONB support, result streaming, error highlighting, snippets, and more
Agentic workflows for data intensive tasks
Turn prompts into reusable workflow runs that can combine database actions, MCP tools, and optional agent steps. Workflows execute in an isolated environment with controlled permissions, inputs, progress tracking, logs, and re-run support.
Generate Dashboards
Create interactive dashboards from simple prompts.
The assistant suggests visualizations and layouts that best communicate your insights.
Secure MCP tool integration
Use MCP tools with access controls to safely perform tasks like data enrichment, advanced analysis, and workflow automation.
Ask questions about your data
Ask questions in natural language and get answers grounded in your database schema.
The assistant can generate tailored SQL, explain query logic, and help you investigate trends, anomalies, and relationships in your data.
Multimodal input: text, files, and speech-to-text
Interact with the AI assistant using voice.
Convert spoken language into text prompts for a hands-free experience.
Upload files to extract data or provide additional context.
Fast and relevant suggestions
Schema, data and context-aware autocomplete suggestions that show a
realtime view of the database objects. Powered by Monaco Editor, our
SQL editor allows you to edit code more efficiently. Move blocks of
code, use multi-cursors to manage selections, and other features.
Charts
Create charts directly from query results to visualize data trends and
patterns without needing to export data to external tools.
Available charts include bar, line and map charts.
JSONB support
Easily query and manipulate JSONB data with specialized autocomplete
suggestions for JSONB functions and operators, as well as key and
value suggestions based on the actual JSONB data stored in your
database.
Backup and Restore options
Manual and automatic backups can be initiated through a couple of
clicks. Backup and restore options for pg_dump and pg_retore are
configurable through the UI. Backups can be stored on AWS S3 compatible storage providers or locally
