About this software
Database Designer for PostgreSQL is a diagram-based tool for designing, generating, and maintaining PostgreSQL databases. It provides visual schema modeling, reverse engineering of existing databases, and generates SQL scripts and ALTER statements to apply diagram changes.
The product can export diagrams to common image formats, produce structure reports, and supports PostgreSQL objects such as schemas, tables, indexes, triggers, views, stored procedures, and domains. It runs on Windows and can operate on Linux under Wine.
Licenses & prices
Business
Business edition is licensed for organizational use, supporting team deployment and administrative controls for PostgreSQL schema design.
Personal
Personal edition is intended for individual, non-commercial use, providing single-user PostgreSQL design and local project storage.
Commercial
Commercial edition permits paid or revenue-generating use of the PostgreSQL designer with standard single- or multi-seat licensing terms.
Purchase
MicroOLAP Database Designer for PostgreSQL
In Stock
Delivery: 1 working day
Loading...
€132.00
Free and without obligation
Do you need more information or looking for another license?
Benefits
- Visual schema modeling: Build and edit PostgreSQL schemas using diagram-based tools.
- Reverse engineering: Import existing databases into visual diagrams for analysis and modification.
- SQL generation and modification: Generate CREATE and ALTER scripts to apply diagram changes.
- Export and reports: Export diagrams to common image formats and generate reports.
- Platform compatibility: Runs natively on Windows and can run on Linux via Wine.
Available languages
- English
Support information
- Product documentation: User manual and help pages are available on the product documentation site.
- Support ticketing system: A support ticketing system is available via the Microolap support portal.
- Downloads and updates: Downloads and maintenance releases are provided from the product downloads page.
- Release notes: News and changelogs are posted on the website with version details.
- Ordering and subscriptions: Ordering and subscription information is available through the site's order pages.
Frequently asked questions
What does Database Designer for PostgreSQL do?
It provides visual modeling, reverse engineering, SQL script generation, and tools to modify and synchronize PostgreSQL databases based on diagrams.
Which PostgreSQL objects are supported?
Supports schemas, tables, columns, indexes, constraints, foreign keys, views, triggers, stored procedures, functions, and domains.
Can it import databases from other systems?
Yes; it can reverse-engineer databases accessible via OLE DB or ODBC, including MySQL, Oracle, MSSQL, DB2, and Access.
How are diagram changes applied to a live database?
The tool generates SQL scripts and ALTER statements and can synchronize database structures to match the diagram.
Which operating systems does it support?
It runs natively on Windows and is reported to run on Linux under Wine/WineHQ.