SaaSHub helps you find the best software and product alternatives Learn more →
Top 23 Shell Postgresql Projects
-
DevOps-Bash-tools
1000+ DevOps Bash Scripts - AWS, GCP, Kubernetes, Docker, CI/CD, APIs, SQL, PostgreSQL, MySQL, Hive, Impala, Kafka, Hadoop, Jenkins, GitHub, GitLab, BitBucket, Azure DevOps, TeamCity, Spotify, MP3, LDAP, Code/Build Linting, pkg mgmt for Linux, Mac, Python, Perl, Ruby, NodeJS, Golang, Advanced dotfiles: .bashrc, .vimrc, .gitconfig, .screenrc, tmux..
View the Project on GitHub
-
Stream
Stream - Scalable APIs for Chat, Feeds, Moderation, & Video. Stream helps developers build engaging apps that scale to millions with performant and flexible Chat, Feeds, Moderation, and Video APIs and SDKs powered by a global edge network and enterprise-grade infrastructure.
-
-
Though these providers often get attention, other services such as ScaleGrid, Crunchy Data, IBM Cloud Databases for PostgreSQL, and ElephantSQL also provide useful features. Each one meets different needs, including flexibility, security, or ease of use. This makes them good options to think about for certain business purposes or smaller projects.
-
docker-postgres-backup-local
Backup PostgresSQL to local filesystem with periodic backups and rotate backups.
I was using straight filesystem backups for a while, but I knew they could be inconsistent. Since then, I've setup https://github.com/prodrigestivill/docker-postgres-backup-lo..., which regularly dumps a snapshot to the filesystem, which regular filesystem backups can consume. The README has restore examples, too
I haven't needed to tune selfhosted databases. They do fine for low load on cheap hardware from 10 years ago.
-
Project mention: pgautoupgrade – PostgreSQL Docker image to automatically upgrade your database | news.ycombinator.com | 2025-02-12
-
docker-postgresql-multiple-databases
Using multiple databases with the official PostgreSQL Docker image
-
-
InfluxDB
InfluxDB – Built for High-Performance Time Series Workloads. InfluxDB 3 OSS is now GA. Transform, enrich, and act on time series data directly in the database. Automate critical tasks and eliminate the need to move data externally. Download now.
-
Project mention: Deploying a NestJS and Next.js Application on Dokku: Full-Stack Architecture | dev.to | 2025-02-22
# Example for database dokku plugin:install https://github.com/dokku/dokku-postgres.git dokku postgres:create mydatabase dokku postgres:link mydatabase my-nestjs-app # Example for environment variables dokku config:set my-nestjs-app \ APP_PORT=5000 \ NGINX_ROOT=dist \ JWT_SECRET=xxxxxxxxxxxxxxxxxx
-
-
-
embedded-postgres-binaries
Lightweight bundles of PostgreSQL binaries with reduced size intended for testing purposes.
-
Some examples from me:
Database benchmarks: https://github.com/ClickHouse/ClickBench (containing 30+ databases) and the new JSON analytics benchmark, https://github.com/ClickHouse/JSONBench/
Plus, the hardware benchmark: https://benchmark.clickhouse.com/hardware/ (also used by Phoronix).
-
firebolt-core
Firebolt Core is a free, self-hosted edition of Firebolt's distributed query engine (https://www.firebolt.io/); it provides high-performance data warehousing capabilities that can be deployed anywhere from a single laptop to enterprise datacenters.
Project mention: Show HN: Firebolt Core – #1 in ClickBench – Free Scale-Out Analytical SQL Engine | news.ycombinator.com | 2025-06-25 -
The index maintenance is not a one-time operation, but rather a periodic task that should be run regularly to keep the index in good shape. The frequency of the maintenance depends on the workload and the size of the outbox_unpublished partition. You can use the pg_cron extension to schedule the maintenance task, or use a job scheduler like cron or K8s CronJobs to run the REINDEX command periodically. There's also a nice bash script by Vitaliy Kukharik, called pg_auto_reindexer, which can run during the set time and reindex all the indexes that are bloated more than a certain threshold. It can be used to automate the index maintenance process.
-
devcontainer-rails
💎 devcontainer configurations to run Ruby on Rails with PostgreSQL and Redis on GitHub Codespaces (or locally)
-
Open-COBOL-ESQL
Open Cobol ESQL (ocesql) is an open-source Embedded SQL pre-compiler and run-time library designed for COBOL applications which access an open-source database.
-
-
pg_auto_failover_ansible
Ansible Playbook(s) to create/manage a cluster of PostgreSQL nodes running in a cluster with pg_auto_failover
-
-
-
dumputils-container
Container image which provides easy access to most backup/restore utils used for managing database backups.
-
-
-
SaaSHub
SaaSHub - Software Alternatives and Reviews. SaaSHub helps you find the best software and product alternatives
NOTE:
The open source projects on this list are ordered by number of github stars.
The number of mentions indicates repo mentiontions in the last 12 Months or
since we started tracking (Dec 2020).
Shell Postgresql discussion
Shell Postgresql related posts
-
Embedded Postgres Binaries
-
Hands-On WrenAI Review: Text-to-SQL Powered by RAG
-
Deploying a NestJS and Next.js Application on Dokku: Full-Stack Architecture
-
pgautoupgrade – PostgreSQL Docker image to automatically upgrade your database
-
Hosting your own PaaS: Open-Source Tools to Help You Exit the Cloud!
-
dokploy VS Dokku - a user suggested alternative
2 projects | 26 Aug 2024 -
Host your own PaaS (platform as a service) on Amazon Web Services
-
A note from our sponsor - SaaSHub
www.saashub.com | 9 Jul 2025
Index
What are some of the best open-source Postgresql projects in Shell? This list will help you:
| # | Project | Stars |
|---|---|---|
| 1 | DevOps-Bash-tools | 6,878 |
| 2 | startpack | 1,239 |
| 3 | crunchy-containers | 1,025 |
| 4 | docker-postgres-backup-local | 958 |
| 5 | docker-pgautoupgrade | 834 |
| 6 | docker-postgresql-multiple-databases | 733 |
| 7 | hypertrace | 520 |
| 8 | dokku-postgres | 503 |
| 9 | shmig | 467 |
| 10 | elephant-shed | 219 |
| 11 | embedded-postgres-binaries | 176 |
| 12 | JSONBench | 141 |
| 13 | firebolt-core | 133 |
| 14 | pg_auto_reindexer | 98 |
| 15 | devcontainer-rails | 87 |
| 16 | Open-COBOL-ESQL | 57 |
| 17 | localhost-databases | 50 |
| 18 | pg_auto_failover_ansible | 31 |
| 19 | cloud-native-platform | 29 |
| 20 | ybdemo | 16 |
| 21 | dumputils-container | 14 |
| 22 | data_origination_workshop | 13 |
| 23 | dbdb | 10 |
Sponsored
Stream - Scalable APIs for Chat, Feeds, Moderation, & Video.
Stream helps developers build engaging apps that scale to millions with performant and flexible Chat, Feeds, Moderation, and Video APIs and SDKs powered by a global edge network and enterprise-grade infrastructure.
getstream.io