Internal tool builder and IDE for PostgreSQL

Free and Open SourceGithub

Typescript API
Storage
2FA
Access control

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

Access control

  • Role based access rules

    Custom roles can be defined to control access to databases, workspaces, tables rows and columns

File storage

  • Cloud (AWS S3) or Local

    Store and serve files locally or on the cloudd
    Files are managed through the file table or any other column that references the file table.
    Access rules can be applied to limit the accepted file types and sizes

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.

Typescript API

  • End-to-End Type Safety

    Database schema types are generated and used in providing runtime safety and improved developer experience
    Filters, select and order by clauses are typed. Select clauses are used in infering the resulting type
    React hooks are available to simplify the process of fetching, subscribing to, and manipulating data within your React components