Search and explore
Search data, open tables, run SQL, visualize schema relationships, switch workspaces, and launch tools—all in one flexible, customizable workspace
Table view
Explore related data without losing context.
View related records inside the data card side panel.
Add related table data as columns in the main table view.
Cross-filtered tables and charts
## Features
- **Smart filtering and search**: Use the smart filter bar to quickly filter your data based on column types and values.
- **Multiple display modes**: View the same data as a table, JSON, or card layout with grouping (Kanban style) and ordering options.
- **Computed columns and functions**: Derive new values, aggregate data, and apply functions without changing the underlying table.
- **Linked data and joins**: Pull in fields from related tables, control join type, aggregate, and filter or sort nested data.
- **Charts, maps, and cross-filtering**: Turn table data into timecharts and maps, or open linked views that stay cross-filtered with the current selection.
- **Live data refresh**: Use realtime subscriptions to both tables and views to keep table data current.
- **Smart forms**: Edit rows using smart forms that adapt to your schema and data types.
- **Conditional styling**: Style your columns based on value, including inline bar charts and timecharts.
- **Rich column styling and display formats**: Inline timechart and bar-chart rendering as well as value-based colours and styles, while also rendering emails, phone numbers, URLs, QR codes, currency, HTML, and media or image URLs in more useful formats.
- **Postgres-aware management**: Access table info, columns, indexes, constraints, triggers, policies, and access rules from the table menu.
Timechart
Create multi-layer charts to visualize data relationships.
Combine multiple chart types, such as bars and lines, to show different aspects of your data in a single view.
## Features
- **Multiple layer support**: Display multiple layers of time-series data on the same chart, each with its own data source and styling options.
- **Aggregation and grouping**: Configure aggregation functions and grouping options for each layer to analyze trends and patterns in your data effectively.
- **Interactive exploration**: Interact with the chart using zooming, panning, and tooltips to explore your data in detail.
Map
Visualize PostGIS data.
Plot points, lines, and polygons on maps to analyze spatial relationships in your data.
Add multiple cross-filtered layers to visualize different types of geospatial data together.
Add or edit geospatial data directly from the map view.
# Features
- **Multiple layer support**: Display multiple layers of geographical data on the same map, each with its own data source and styling options.
- **Data-driven styling**: Style your map layers with custom colors or icons based on the attributes of your geographical data for better visualization.
- **Custom basemaps**: Choose from different basemap options or add your own custom tiles for the map background.
- **Map controls**: Interact with the map using controls for zooming, panning, and displaying cursor coordinates.
SQL editor
Write and run SQL queries with an integrated editor that supports syntax highlighting, autocompletion, and query history.
Save and organize your queries for easy access and reuse. Schema and data-aware autocompletion helps you write queries faster and with fewer errors.
View query results in sortable table, map or timechart for further analysis.
### Features
- **Intelligent auto-completion** with context-aware suggestions based on your schema and data with JSONB property access support
- **Rich suggestion details** with related objects, usage examples and documentation extracts, reducing the need to switch context
- **Execute current statement** functionality to run only the SQL statement where the cursor is located
- **Charting options** to visualize query results as timecharts or maps directly from the editor
- **Multiple result display modes** including table, map, timechart, JSON, and CSV formats
Customizable workspace
Arrange your workspace to fit your workflow in a flexible grid or tabbed layout.
Open multiple tables, charts, and tools side by side.
Drag and drop to rearrange your workspace.
Save and switch between different workspace layouts for different tasks or projects.
AI assistant
Get instant insights and assistance with your data.
Perform ETL tasks in isolated environments with strict tool and database access control.
Generate visualizations, and explore your data more effectively.
# Features
- **Agentic Workflows**: Generate, save and re-run TypeScript automations in an isolated sandbox with granular access to data, MCP tools and filesystem.
- **Progressive schema discovery**: Each conversation fetches only the table and tool schemas it actually needs, keeping the context window clean and focused.
- **Granular per-chat permissions**: Configure database access, schema visibility, and tool permissions independently for each conversation
- **Works with hosted and local models**: It supports OpenAI, Anthropic, Gemini, OpenRouter, Ollama, and OpenAI-compatible local models.
- **Multimodal input**: Attach files, convert supported documents and images into markdown context, and local speech-to-text.