Skip to main content
35 votes

Generate database table diagrams from a PostgreSQL database

DBeaver free, multi-platform universal SQL client. Supports all popular databases: MySQL, PostgreSQL, MariaDB, SQLite, Oracle, DB2, SQL Server, Sybase, MS Access, Teradata, Firebird, Derby, etc. You ...
Akshay Gupta's user avatar
9 votes

Generate database table diagrams from a PostgreSQL database

Inspired by the answer by @arman-fatahi, here is a more detailed instruction how to create DB diagrams using draw.io: Dump the schema of your database - e.g. for PostgreSQL, the command might be: ...
natka_m's user avatar
  • 191
6 votes

Generate database table diagrams from a PostgreSQL database

You may use "Microolap Database Designer for PostgreSQL" aka PgMDD It's a commercial software with 30-day trial though. Personal\Educational license will cost $124.95, however you may get a free ...
Pavlo Golub's user avatar
5 votes

Generate database table diagrams from a PostgreSQL database

You can use SQL Power Architect: Most features are free, including the ER schema generation Microsoft Windows / Mac OS X / Linux Supports most commonplace DBMS suggest MySQL and PostgreSQL You just ...
Franck Dernoncourt's user avatar
4 votes

PostgreSQL database explorer

I use pgAdmin for this. It meets your requirements as far as I can tell: Works with Windows 7 and onwards Has a visual tree tree with the referencing of the objects in the db Able to write queries
MrCodeWeaver's user avatar
4 votes

Open source or free online dashboard

Syncfusion Dashboard Platform is an option to consider. Dashboards need to be designed using the Dashboard Designer (windows application) and published using the Dashboard Server (web application). ...
Davis Jebaraj's user avatar
4 votes

A light-weight library to expose SQL database tables over HTTP with querying?

You may try nginx HTTP server in conjunction with ngx_postgres module. ngx_postgres allows nginx to communicate with PostgreSQL database. Your basic requirements are satisfied as far as I see: No ...
tysonite's user avatar
  • 333
4 votes

Generate database table diagrams from a PostgreSQL database

Datagrip by Jetbrains. Apart from PostgreSQL it works with various RDBMS (MYSQL, SQL Server, MongoDB,...). They have a 30 day trial and there are various pricing options. Here's how to do it: https://...
Gonçalo Peres's user avatar
3 votes

Generate database table diagrams from a PostgreSQL database

Here is the best way that I found: Export your database schema as SQL. Most databases have a tool for that. Go to Draw.io and open an empty file. Click the plus on the top ( help ) Select from SQL ...
Arman Fatahi's user avatar
2 votes

A light-weight library to expose SQL database tables over HTTP with querying?

Sandman2 does exactly what you want, in python and advertises itself as Automatically generate a RESTful API service for your legacy database. No code required! It uses SQLAlchemy for database ...
Philippe Ombredanne's user avatar
2 votes

A light-weight library to expose SQL database tables over HTTP with querying?

RestifyDB (http://restifydb.com) is one solution. Its opensource and can be used free (unless you need patching etc for which there is a commercial version available. Though i have not used slash DB (...
user1622369's user avatar
2 votes

open source tool for SQL Queries

Pretty much any maintained open-source SQL Editor may be suitable for you. It really depends if you prefer also to be lightweight: Squirrel SQL - small footprint, universal (both source and os), ...
Kube Kubow's user avatar
1 vote

Choosing the right database management system?

There is alway an "it depends" aspect to these type of questions, however let's give it a try. I will give 3 scenario's which you have determine which best describes your situation. Proof of concept /...
Thomas's user avatar
  • 305
1 vote
Accepted

Choosing the framework to an IDE type of web gui

Java Applets The Java Applet route is nearly dead. All the web browser makers are phasing out support for Java Applet and similar plugin execution environments such as Flash and Silverlight because ...
Basil Bourque's user avatar
1 vote

Solution for a Data warehouse of about 7 GB

If your flat file is CSV mysql has a built in import tool, as I am sure other products have a similar feature. Logging of course can be setup. Now with this small data set you have many options if ...
cybernard's user avatar
  • 1,724
1 vote
Accepted

tools to create SQL queries through a graphical interface

On PgAdmin3, there is a graphical query builder (see the right tab on the upper left side of the animated gif)
Andy K's user avatar
  • 137
1 vote

Open source or free online dashboard

Have a look at Subrion (https://subrion.org/). Easy to install, uses just php and mysql, can be installed with Softaculous. Not sure if it work with Postgre as I only installed yesterday and so am ...
garrettlynchirl's user avatar
1 vote

Web interface where I can draw objects and export PostGIS insert statements

If you are looking for a solution that works in a web interface (to allow edits in a browser to be added to your server based database) you should look at GIS server software that provides ...
nmtoken's user avatar
  • 147
1 vote

Reporting - easy to build interface linked to a postgres database

I recommend you to give DBxtra a try, it connects to Postgres directly, it's self hosted, and can be accessed from any computer with just a web browser, also, it's easy to use and have interactivity ...
Miguel Garcia's user avatar
1 vote

Reporting - easy to build interface linked to a postgres database

DISCLAIMER: I WORK AT QUERYTREE I've tried to interpret your question, you mention self-hosted (in a tag) and also web-based, so I'm actually going to suggest a couple of SaaS solutions - one with a ...
a_good_swan's user avatar
1 vote

PostgreSQL database explorer

pgAdmin is the best option because it is built for PostgreSQL only. I am using pgAdmin and Database .NET, Database .NET is my favorite since it has many good features which pgAdmin doesn't. It is ...
w͏̢in̡͢g͘̕ed̨p̢͟a͞n͏͏t̡͜͝he̸r̴'s user avatar
1 vote

Generate database table diagrams from a PostgreSQL database

Try DbSchema, it's commercial software with free trial. It works with a couple of RDBMS and NoSQL databases. It generates interactive diagrams with clear layout and can export to SVG/png/jpg.
michaelliu's user avatar
1 vote
Accepted

PostgreSQL front end for adding, viewing and updating values

If you take django you get the admin interface with nearly no extra work. AND: you get a tool to handle database schema migrations. I recommend it.
guettli's user avatar
  • 207
1 vote

PostgreSQL front end for adding, viewing and updating values

pgAdmin could be the tool of your choice: pgAdmin (source: pgAdmin; click image for larger variant) As the screenshot shows, it should match your needs quite fine: a form layout to add and modify ...
Izzy's user avatar
  • 18.8k
1 vote

Simple business intelligence tool for scheduled reports

I was on the same boat as you and then I found Metabase. is free - Yes, it's Open Source can be deployed on premise (not in a cloud) - Yes it has 5 minute installation and it's true can work with ...
Sonamor's user avatar
  • 1,133
1 vote

Simple business intelligence tool for scheduled reports

I would suggest taking a look at Python plus Pandas is free both Gratis & Open Source can be deployed on premise (not in a cloud) Yes can work with PostgresDB Yes - just about any DB allows to ...
Steve Barnes's user avatar
  • 31.7k
1 vote

Sort pg_dump output

There is a tool called pgtricks which does this. From the docs: pg_dump_splitsort is a handy script for pre-processing PostgreSQL's pg_dump output to make it more suitable for diffing and storing in ...
guettli's user avatar
  • 207
1 vote

Postgres/PostGIS GUI aplication development tools

Vaadin is a framework for writing user-interfaces for web apps in pure Java while automatically converting to standard web technologies in the client web browser. So no need to know HTTP, HTML, CSS, ...
Basil Bourque's user avatar
1 vote

Postgres/PostGIS GUI aplication development tools

I hate paying for software, so when I do, I make sure there isn't anything free that can do the job. In the case of PostgreSQL, a lot of free software exists that claim they are GUI but for a simple ...
Tom's user avatar
  • 7,729

Only top scored, non community-wiki answers of a minimum length are eligible