The SQL Power Architect data modeling and profiling tool provides many unique features geared specifically for the data warehouse architect. Whether you are building a data warehouse or using data models to communicate business rules, SQL Power Architect will facilitate and automate your data modeling efforts. This data type lets you generate tree-like data in which every row is a child of another row - except the very first row, which is the trunk of the tree. This data type must be used in conjunction with the Auto-Increment data type: that ensures that every row has a unique numeric value, which this data type uses to reference the parent rows. EMS PostgreSQL Data Generator 2.0 utility are now available online under www.sqlmanager.net. It can be downloaded from download page. What is EMS PostgreSQL Data Generator? EMS Data Generator is a powerful utility for generating test data to several PostgreSQL database tables at once. Generate You need provide basic information about your hardware configuration, where is working PostgreSQL database. Results will be calculated after clicking 'Generate' button. I want to generate big data sample (almost 1 million records) for studying tuplesort.c's polyphase merge in postgresql, and I hope the schema as follows: CREATE TABLE Departments (code VARCHAR(4).
- Dummy Data Generator
- Postgresql Data Generator Online Hack
- Postgresql Data Generator
- Postgresql Data Generator Online No Human
- Import Data Postgresql
- Postgresql Data Generator Online Download
List of data modeling and database design tools.
ER/Studio
![Test Test](https://el.hostadvice.com/share-image/ehost-internet-data-center-ehost-idc.jpeg)
ER/Studio provides robust logical and physical modeling and determines all data sources along with managing the transformation of data between the staging area and data warehouse. It helps to build out an enterprise data model and represent business concepts with full documentation of attributes, definitions, relationships, etc.
Desktop/Cloud: | Desktop |
---|---|
Commercial: | Commercial |
Free edition: | |
ER Diagram: | |
Runs on: (for desktop): | Windows |
Forward engineering: | |
Reverse enginering: | |
Synchronization: | - |
GenMyModel
GenMyModel is a modeling platform in the cloud for software architects and developers. It enables to create Archimate, BPMN and Flowchart diagrams with ease, for more efficient business processes and models.
Desktop/Cloud: | Cloud |
---|---|
Commercial: | Commercial |
Free edition: | |
ER Diagram: | |
Runs on: (for desktop): | - |
Forward engineering: | |
Reverse enginering: | |
Synchronization: | - |
MagicDraw
MagicDraw is the award-winning business process, architecture, software and system modeling tool with teamwork support. Cameo Data Modeler plugin for MagicDraw provides data-related modeling features. MagicDraw provides intuitive controls within a very well designed GUI which allows users to model without having to spend time learning about the controls.
Desktop/Cloud: | Desktop |
---|---|
Commercial: | Commercial |
Free edition: | |
ER Diagram: | |
Runs on: (for desktop): | Linux,Mac OS,Windows |
Forward engineering: | |
Reverse enginering: | |
Synchronization: | - |
RISE
RISE is a software suite for Information System Engineering. It's a tool for model driven system development, packed with features and functions needed to build your information model and to turn it into a complete information management solution.
Desktop/Cloud: | Desktop |
---|---|
Commercial: | Free |
Free edition: | |
ER Diagram: | |
Runs on: (for desktop): | Windows |
Forward engineering: | |
Reverse enginering: | |
Synchronization: | - |
Moon Modeler
Moon modeler is a visual database designer tool for MongoDB. The key features include the visual design of hierarchical structurs, MongoDB script generation, various display modes, possibility to add custom notes to diagram and more.
Desktop/Cloud: | Desktop |
---|---|
Commercial: | Commercial |
Free edition: | |
ER Diagram: | |
Runs on: (for desktop): | Linux,Mac OS,Windows |
Forward engineering: | |
Reverse enginering: | |
Synchronization: |
DB-Main
Rever DB-Main is an easy-to-use data modeling and data architecture platform. The tool offers powerful components rarely seen in standard data modeling tools. The main features are model neutrality, reverse engineering, methodology neutrality, programmable and extensible, short error detection/fixing cycle.
Desktop/Cloud: | Desktop |
---|---|
Commercial: | Commercial |
Free edition: | |
ER Diagram: | |
Runs on: (for desktop): | Windows |
Forward engineering: | |
Reverse enginering: | |
Synchronization: | - |
Enterprise Architect
Enterprise Architect is a multi-user, graphical tool designed to help enterprises built logical and physical data models. It provides complete traceability from requirements, analysis and design models, through to implementation and deployment.
Desktop/Cloud: | Desktop |
---|---|
Commercial: | Commercial |
Free edition: | |
ER Diagram: | |
Runs on: (for desktop): | Linux,Mac OS,Windows |
Forward engineering: | |
Reverse enginering: | |
Synchronization: | - |
ModelSphere
ModelSphere is an exciting and unique modeling tool that combines many features, such as business process modeling, data modeling and UML modeling, and provides a flexible model management environment. It provides complete data modeling features covering conceptual, logical and physical modeling.
Desktop/Cloud: | Desktop |
---|---|
Commercial: | Free |
Free edition: | |
ER Diagram: | |
Runs on: (for desktop): | Linux,Windows |
Forward engineering: | |
Reverse enginering: | |
Synchronization: | - |
PowerDesigner
PowerDesigner DataArchitect is the industry-leading data modeling tool. It offers a model-driven approach to empower and align business and IT. PowerDesigner enables enterprises to more easily visualize, analyze and manipulate metadata for effective enterprise information architecture.
Desktop/Cloud: | Desktop |
---|---|
Commercial: | Commercial |
Free edition: | |
ER Diagram: | |
Runs on: (for desktop): | Linux,Mac OS,Windows |
Forward engineering: | |
Reverse enginering: | |
Synchronization: | - |
SQL Power Architect
Smart utility 3 2 5. The SQL Power Architect data modeling and profiling tool provides many unique features geared specifically for the data warehouse architect. Whether you are building a data warehouse or using data models to communicate business rules, SQL Power Architect will facilitate and automate your data modeling efforts.
Desktop/Cloud: | Desktop |
---|---|
Commercial: | Commercial |
Free edition: | |
ER Diagram: | |
Runs on: (for desktop): | Mac OS,Windows |
Forward engineering: | |
Reverse enginering: | |
Synchronization: | - |
X-TEA Modeler
X-TEA Modeler helps you write models and plans of enterprise systems. Its editor helps you to write specifications of tables, functions and also to create/alter tables in your database.
Desktop/Cloud: | Desktop |
---|---|
Commercial: | Free |
Free edition: | |
ER Diagram: | |
Runs on: (for desktop): | Windows |
Forward engineering: | |
Reverse enginering: | |
Synchronization: | - |
Tools to help with designing a schema, via creating Entity-Relationship diagrams and similar. Most are GUI.
List also includes tools to help with 'visualization' or 'documentation' of already existing databases.
For tools to 'run SQL and see its output' see PostgreSQL Clients.
- 1Windows
- 1.1Proprietary
- 2Cross-Platform
- 2.1Open Source (Free)
- 2.2Proprietary
- 3Commandline Tools
- 4Unknown
Windows
Proprietary
pgModeler
Windows / Linux / macOS
This is open source (GPLv3) and can be freely built yourself, if you have Qt available, but downloadable binaries appear to be time-limited demos that can be unlocked with paypal.
Aqua Data Studio
The Aqua Data Studio Entity Relationship Modeler (ER Modeler) helps you design complex database models for all major RDBMS vendors and versions. Use the Forward Engineer feature to model entities and convert them into SQL Scripts, or Reverse Engineer existing databases to visualize a database model.
DeZign
An intuitive database design and modeling tool for developers and DBA's that can help you model, create and maintain databases. The software uses entity relationship diagrams (ERDs, data models) to graphically design databases and automatically generates the most popular SQL and desktop databases.
ERBuilder Data Modeler
ERBuilder Data Modeler is a GUI data modeling tool that allows developers to visualize, design, and model databases by using entity relationship diagrams and automatically generates the most popular SQL databases. Generate and share the data Model documentation with your team. Optimize your data model by using advanced features such as test data generation, schema compare, and schema synchronization.
PostgreSQL Maestro
Toad Data Modeler
Toad Data Modeler enables you to rapidly deploy accurate changes to data structures across more than 20 different platforms. It allows you to construct logical and physical data models, compare and synchronize models, quickly generate complex SQL/DDL, create and modify scripts, as well as reverse and forward engineer both databases and data warehouse systems.
May have free versions? Website is a bit of a wreck.
EMS SQL Manager
Cross-Platform
Open Source (Free)
Kexi
A visual database application creator, c.f. Access or FileMaker. Windows/linux.
Open System Architect
Windows / macOS / Linux / Solaris
OSA currently supports data modelling (physical and logical) with UML in the works.
SQL Power*Architect
Java
The SQL Power Architect data modeling tool was created by data warehouse designers and has many unique features geared specifically for the data warehouse architect. It allows users to reverse-engineer existing databases, perform data profiling on source databases, and auto-generate ETL metadata.
Valentina Studio
Windows / macOS / Linux
Free version supports reverse-engineering an existing schema, but only the proprietary version supports forward-engineering.
Open ModelSphere
Java
Open ModelSphere is a powerful data, process and UML modeling tool - supporting user interfaces in English and French.
Umbrello
Windows / macOS / Linux
Umbrello UML Modeller is a Unified Modelling Language (UML) diagram program based on KDE Technology.
UML allows you to create diagrams of software and other systems in a standard format to document or design the structure of your programs.
ERDesignerNG
Java, GPL
Proprietary
DbSchema
Windows / macOS / Linux / Java
Features interactive diagrams, relational data browse, schema compare and synchronization, query builder, query editor, HTML5 documentation, random data generator, forms and reports.
DbVisualizer
Windows / macOS / Linux / Java
A client that does a lot of things other than schema design. It has a free version that provides many of the features, but not apparently design and DDL export. DbVisualizer is a feature rich, intuitive multi-database tool for developers, database administrators, and increasingly for advanced analysts providing a single powerful interface across a wide variety of operating systems. With its easy-to-use and clean interface, DbVisualizer has proven to be one of the most cost effective database tools available, yet to mention that it runs on all major operating systems and supports all major RDBMS that are available. Users only need to learn and master one application. DbVisualizer integrates transparently with the operating system being used. The hit list 1 1 20.
DbWrench
Windows / macOS / Linux / Java
Diagramming / Forward & Reverse Engineering
Moon Modeler
Windows / macOS / Linux
Features:
- Database modeling
- Visualization of nested structures and JSON
- SQL script generation
- Reverse engineering
- Support for PostgreSQL specifics, modeling of composite types, hierarchical JSON structures etc.
- GraphQL schema design
StarUML
Windows / macOS / Ubuntu
https://github.com/adrianandrei-ca/staruml-postgresql - extension to support PostgreSQL
(This is version 2. The much older, open source version 1 is available at http://staruml.sourceforge.net/v1/download.php)
Vertabelo
Vertabelo is an online database designer working under Chrome. It free to use for smaller projects and have a proprietary versions for larger database projects.
- Intuitive HTML5 web interface (Chrome)
- OS independent
- Sharing DB model with team members
- Support for PostgreSQL, MySQL, Oracle, MS SQL Server, DB2, SQLite, HSQLDB,
- Model versioning
- Dynamic/Visual search
- Live model validation
- Reverse engineering
Abris Platform
Web Application for Linux/Windows, requires Apache+PHP or Docker
Abris Platform is an application development platform for creating Web-based front-ends for PostgreSQL databases. Can be used to quickly create applications with convenient forms via SQL declarative description.
Allows to create, alter and drop tables, views, foreign keys, triggers.
Navicat
Windows, macOS, iOS
A general purpose client with good modeling features.
Commandline Tools
Tools that take a description of a database schema in one format and convert it to SQL, and sometimes vice-versa.
SQLFairy
Perl, manipulate structured data definitions (mostly database schemas) in interesting ways, such as converting among different dialects of CREATE syntax (e.g., MySQL-to-Oracle), visualizations of schemas (pseudo-ER diagrams: GraphViz or GD), automatic code generation (using Class::DBI), converting non-RDBMS files to SQL schemas (xSV text files, Excel spreadsheets), serializing parsed schemas (via Storable, YAML and XML), creating documentation (HTML and POD), and more.
DbVisualizer
Windows/OS X/Linux/UNIX
DbVisualizer is a feature rich, intuitive multi-database tool for developers, database administrators, and increasingly for advanced analysts providing a single powerful interface across a wide variety of operating systems. With its easy-to-use and clean interface, DbVisualizer has proven to be one of the most cost effective database tools available, yet to mention that it runs on all major operating systems and supports all major RDBMS that are available. Users only need to learn and master one application. DbVisualizer integrates transparently with the operating system being used.
schemalint
A tool to verify the database schema against Don't Do This recommendations.
Unknown
Autodoc
Dummy Data Generator
perl, open source
This is a utility which will run through PostgreSQL system tables and returns HTML, DOT, and several styles of XML which describe the database.
As a result, documentation about a project can be generated quickly and be automatically updatable, yet have a quite professional look if you do some DSSSL/CSS work.
Schema Spy
LGPLv3 Java based console tool to auto-generate documentation in HTML format for an existing database. It uses viz.js or, optionally, Graphviz to render ERD diagrams. It can render markdown for database object comments. Also it allow some basic preprocessing defined with XML configuration file such as implied relationships, column suppression, foreign/remote tables.
SQLFairy
Perl, manipulate structured data definitions (mostly database schemas) in interesting ways, such as converting among different dialects of CREATE syntax (e.g., MySQL-to-Oracle), visualizations of schemas (pseudo-ER diagrams: GraphViz or GD), automatic code generation (using Class::DBI), converting non-RDBMS files to SQL schemas (xSV text files, Excel spreadsheets), serializing parsed schemas (via Storable, YAML and XML), creating documentation (HTML and POD), and more.
DB Doc
Windows/Linux(Wine)
DB Doc helps you document your database structure and objects. Documents can be generated as PDF reports, HTML pages, Microsoft Word (docx) file, or a single compiled HTML file. The layout is fully customizable, and you can quickly view inter-object dependencies using hyperlinks.
MicroOLAP Database Designer
Windows ODBC
Postgresql Data Generator Online Hack
Database Designer for PostgreSQL is an easy CASE tool with an intuitive graphical interface allowing you to build a clear and effective database structure visually, see the complete picture (diagram) representing all the tables, references between them, views, stored procedures and other objects. Then you can easily generate a physical database on a server, modify it according to any changes you made to the diagram using fast ALTER statements.
GenMyModel
GenMyModel is an online modeling tool supporting database modeling. It is free to use for smaller projects and have a proprietary version for larger database projects.
Postgresql Data Generator
Features:
- Intuitive HTML5 web interface (Chrome, Firefox, Safari, Internet Explorer)
- OS independent
- Instant sharing and collaboration
- Customizable SQL generators
- Model versioning
- Live model validation
Postgresql Data Generator Online No Human
dbForge Studio for PostgreSQL
ModelRight
WaveMaker
Import Data Postgresql
??? Doesn't seem to mention Postgres.
Other Resources
- Community Guide to PostgreSQL GUI Tools miscellaneous utilities
- PostgreSQL Clients GUI SQL clients
- Old possibly abandoned projects, see Community_Guide_to_PostgreSQL_Tools_Abandoned
Postgresql Data Generator Online Download
Retrieved from 'https://wiki.postgresql.org/index.php?title=Design_Tools&oldid=35391'