Operational Workspace for PostgreSQL

Build internal tools, dashboards, and manage your PostgreSQL database with Prostgles UI, the open-source IDE designed for developers and teams.

/screenshots/svgif-scenes/schema_diagram_02.svg

Explore and edit linked data

Add related table data and aggregations with a couple of clicks
/screenshots/linked_data.svg

Create dashboards

Cross-filtered views with a variety of visualization types including charts, maps, tables, and more
/screenshots/linked_data.svg

AI Assistant

Create dashboards, analyse and augment data using natural language prompts under strict data access rules. Supports MCP tools and a variety of proprietary and open source models
/screenshots/linked_data.svg

SQL Editor

Fast and relevant autocomplete suggestions to create complex queries and views. JSONB support, result streaming, error highlighting, snippets, and more
/screenshots/linked_data.svg

Agentic workflows for data intensive tasks

Turn prompts into reusable workflow runs that can combine database actions, MCP tools, and optional agent steps. Workflows execute in an isolated environment with controlled permissions, inputs, progress tracking, logs, and re-run support.
/screenshots/ai_assistant.svg

Generate Dashboards

Create interactive dashboards from simple prompts. The assistant suggests visualizations and layouts that best communicate your insights.
/screenshots/ai_assistant.svg

Secure MCP tool integration

Use MCP tools with access controls to safely perform tasks like data enrichment, advanced analysis, and workflow automation.
/screenshots/ai_assistant.svg

Ask questions about your data

Ask questions in natural language and get answers grounded in your database schema. The assistant can generate tailored SQL, explain query logic, and help you investigate trends, anomalies, and relationships in your data.
/screenshots/ai_assistant.svg

Multimodal input: text, files, and speech-to-text

Interact with the AI assistant using voice. Convert spoken language into text prompts for a hands-free experience. Upload files to extract data or provide additional context.
/screenshots/ai_assistant.svg

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.
/screenshots/sql_editor.svg

Charts

Create charts directly from query results to visualize data trends and patterns without needing to export data to external tools. Available charts include bar, line and map charts.
/screenshots/sql_editor.svg

JSONB support

Easily query and manipulate JSONB data with specialized autocomplete suggestions for JSONB functions and operators, as well as key and value suggestions based on the actual JSONB data stored in your database.
/screenshots/sql_editor.svg

Backup and Restore options

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. Backups can be stored on AWS S3 compatible storage providers or locally
/screenshots/backups.svg