PostgreSQL Tools Directory

DBeaver Community: The Universal Database Tool for Developers and Administrators

DBeaver Community is a powerful, free, and open-source database management tool designed for developers, database administrators, and data analysts. It supports a wide range of SQL and NoSQL databases, providing essential features for efficient data management, manipulation, and analysis across various platforms.

DbGate: The Ultimate SQL and NoSQL Database Client

DbGate is a versatile, open-source database client that seamlessly integrates SQL and NoSQL database management, providing users with a powerful tool for data editing, querying, and administration. With support for multiple database engines and a comprehensive set of features, DbGate is designed for developers, data analysts, and database administrators who require efficient database interaction and management across various platforms.

DBGlass is a powerful and intuitive PostgreSQL client that streamlines database management across all major platforms. With its open-source foundation, users can effortlessly create, read, update, and delete data without writing complex SQL queries, making it ideal for both beginners and experienced developers.

Dexter: Automatic Indexing Tool for Postgres

Dexter is an advanced automatic indexing tool designed to optimize query performance in PostgreSQL databases. By analyzing query patterns and identifying slow queries, Dexter helps database administrators automatically create hypothetical indexes, enhancing the speed and efficiency of database operations without necessitating a server restart.

Enhanced Columnar Storage with Citus and cstore_fdw

Citus now integrates columnar storage, enhancing PostgreSQL's capabilities for analytics. It provides a native experience through the table access method API, enabling efficient data handling, improved compression, and seamless integration with distributed tables for optimized query performance across multiple PostgreSQL servers.

Enhanced PostgreSQL EXPLAIN Analysis Tool

The explain.depesz.com tool transforms PostgreSQL's EXPLAIN and EXPLAIN ANALYZE outputs into a user-friendly format, enabling developers to easily interpret query performance metrics. It allows users to save, obfuscate, and manage their query plans, facilitating better optimization and troubleshooting of database queries.

ERAlchemy: Entity Relation Diagram Generator

ERAlchemy is a powerful tool for generating Entity Relation (ER) diagrams directly from databases or SQLAlchemy models. It supports multiple output formats such as PDFs and markdown, making it versatile for various documentation needs and facilitating better database visualization.

Graphile's Crystal Monorepo

Graphile's Crystal Monorepo is a centralized repository that encompasses a suite of powerful tools and libraries designed to enhance GraphQL development, particularly with PostgreSQL databases. The monorepo includes the flagship projects Gra*fast*, a high-performance planning and execution engine, and PostGraphile, an automated GraphQL API generator that adheres to best practices for PostgreSQL integration.

Hasura GraphQL Engine: Powering Modern Application Development

Hasura GraphQL Engine is an open-source tool that accelerates application development by providing a powerful, secure, and composable API for data access. It supports multiple databases including PostgreSQL, MongoDB, ClickHouse, and MS SQL Server, enabling developers to build and scale data-driven applications efficiently.

Heroku Postgres: Reliable Database as a Service

Heroku Postgres is a powerful, fully-managed database service built on PostgreSQL, designed for developers seeking scalability and reliability. With seamless integration across various programming languages and frameworks, Heroku Postgres enables rapid application development and deployment, ensuring high availability and performance for both development and production environments.