Sevalla is the PaaS you have been looking for! Advanced deployment pipelines, usage-based pricing, preview apps, templates, human support by developers, and much more! 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
-
Sevalla
Deploy and host your apps and databases, now with $50 credit! Sevalla is the PaaS you have been looking for! Advanced deployment pipelines, usage-based pricing, preview apps, templates, human support by developers, and much more!
-
-
Databricks recently spent $1 billion to acquire Neon, a startup building a serverless Postgres. Snowflake also spent about $250 million to acquire Crunchy Data, a veteran enterprise-grade Postgres provider.
-
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.
-
> it felt like validation for my little side project
Yep, that can be useful motivation to get a side project past "works for me" through to "works for others".
The pgautoupgrade project (https://github.com/pgautoupgrade/docker-pgautoupgrade) was one of those. It seems to be going ok too, as others have come along and picked up the majority of development (I'm ~outta time). :)
-
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.
-
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 -
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).
-
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.
-
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
-
PG Auto Upgrade – Docker (and K8s) container to auto upgrade your database
-
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 -
A note from our sponsor - Sevalla
sevalla.com | 1 Sep 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 | 7,085 |
| 2 | startpack | 1,244 |
| 3 | crunchy-containers | 1,026 |
| 4 | docker-postgres-backup-local | 985 |
| 5 | docker-pgautoupgrade | 911 |
| 6 | docker-postgresql-multiple-databases | 737 |
| 7 | hypertrace | 520 |
| 8 | dokku-postgres | 507 |
| 9 | shmig | 467 |
| 10 | elephant-shed | 221 |
| 11 | embedded-postgres-binaries | 182 |
| 12 | firebolt-core | 173 |
| 13 | JSONBench | 147 |
| 14 | pg_auto_reindexer | 100 |
| 15 | Open-COBOL-ESQL | 62 |
| 16 | localhost-databases | 51 |
| 17 | pg_auto_failover_ansible | 31 |
| 18 | cloud-native-platform | 29 |
| 19 | ybdemo | 16 |
| 20 | dumputils-container | 14 |
| 21 | data_origination_workshop | 13 |
| 22 | dbdb | 10 |
| 23 | ops-utils | 7 |
Sponsored
Deploy and host your apps and databases, now with $50 credit!
Sevalla is the PaaS you have been looking for! Advanced deployment pipelines, usage-based pricing, preview apps, templates, human support by developers, and much more!
sevalla.com