Internal tool builder and IDE for PostgreSQL
Free and Open SourceGithub
Live demo
Request Full Demo(Limited)
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 bothTable view with easy joining, advanced filtering, sorting, cross filtering, conditional styling, and function application capabilitiesCreate and share interactive dashboards
Workspaces can be published and respect the access rules applied to the underlying dataRealtime charts
Map chart for viewing and editing PostGIS data, enabling real-time geographic data visualization and manipulationTime 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 clouddFiles 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 experienceFilters, select and order by clauses are typed. Select clauses are used in infering the resulting typeReact hooks are available to simplify the process of fetching, subscribing to, and manipulating data within your React components