Cross-platform database tool for PostgreSQL

Free and Open SourceGithub

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'll 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 and edit your data

    Flexible grid layout allows arranging visualizations in tabs, split views, or a combination of both
    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