SQL Editor
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.
Data import
Import JSON, GeoJSON, and CSV files directly into the database, with
automatic inference of column names and data types whenever
possible.
Integrated Documentation
Access official PostgreSQL documentation directly within your code editor. This integration eliminates the need to switch between your editor and a browser, saving you time and keeping you focused on your work. For broader searches, simply use the right-click web search feature.
Comprehensive Database Object Insights
Inspect your database schema more efficiently with rich, in-editor object information. Code completion suggestions include detailed insights into table structures, views, columns, data types, constraints, and user permissions, minimizing the need for context switching.
Error highlighting
Execution error positions are clearly marked, and in many cases, you will receive hints or resolutions to fix issues quickly.
Auto-Saved and Named Queries
Never lose your work with our auto-save feature for current queries. You can also name and save queries for easy access later, ensuring your most important scripts are always at your fingertips.
Flexible Query Execution Modes
Choose from three execution modes: run the current statement, the smallest statement, or the entire script, giving you full control over how you execute your queries.
Snippets
Simplify complex syntax tasks with built-in snippets for functions, triggers, and more. These snippets save time and reduce errors, making your coding process more efficient.
Data explorer and editor
Explore linked data
Add related table data and aggregations with a couple of clicks
Interactive dashboards
Create interactive dashboards with a variety of visualization types including charts, maps, tables, and more
Flexible layout
Flexible grid layout allows arranging visualizations in tabs, split views, or a combination of both
Advanced table view
Table view with easy joining, advanced filtering, sorting, cross filtering, conditional styling, and function application capabilities
Create and share interactive dashboards
Workspaces can be published and respect the access rules applied to the underlying data
Realtime charts
Map chart for viewing and editing PostGIS data, enabling real-time geographic data visualization and manipulation. Time chart for visualizing time series data with a variety of chart types, including line, bar and scatter plots
Backup and Restore
Automatic backups
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
Backup to cloud
Backups can be stored on AWS S3 or locally