Open-Awesome
CategoriesAlternativesStacksSelf-HostedExplore
Open-Awesome

© 2026 Open-Awesome. Curated for the developer elite.

TermsPrivacyAboutGitHubRSS
  1. Home
  2. Tags
  3. Postgresql

Postgresql

689 projects

Showing 36 of 689 projects

sql-to-graphql
sql-to-graphqlJavaScript

A CLI tool that generates a GraphQL API server and schema from an existing SQL database structure.

#database-schema#graphql#cli-tool
Stars590
Forks72
Last commit7 years ago
pgxmock
pgxmockGo

A mock driver for pgx (PostgreSQL driver for Go) to test database interactions without a real database connection.

#pgx#database#postgres
Stars586
Forks69
Last commit4 days ago
pg_stat_monitor
pg_stat_monitorPerl

An advanced PostgreSQL extension for query performance monitoring, aggregating statistics in configurable time buckets.

#hacktoberfest#devops#postgres
Stars580
Forks73
Last commit3 days ago
ape-dts
ape-dtsRust

A Rust-based data transfer suite for ultra-fast replication between MySQL, PostgreSQL, Redis, MongoDB, Kafka, and ClickHouse.

#redis#data-transfer#disaster-recovery
Stars577
Forks95
Last commit2 days ago
Toucan
ToucanClojure

A high-level Clojure library for defining application models and retrieving them from a database with ORM-like conveniences.

#toucan#orm#database
Stars574
Forks48
Last commit2 years ago
pgsql-bloat-estimation
pgsql-bloat-estimation

SQL queries to estimate statistical bloat in PostgreSQL tables and btree indexes.

#sql-queries#database-maintenance#storage-optimization
Stars574
Forks102
Last commit3 years ago
BookLogr
BookLogrJavaScript

A self-hosted web app for managing your personal book library with tracking, sharing, and data export features.

#catalog#library#flask
Stars573
Forks30
Last commit3 days ago
ecto_enum
ecto_enumElixir

An Ecto extension for defining and using enumerations (enums) in Elixir schemas, supporting integer, string, and PostgreSQL enum types.

#database#elixir#custom-enum
Stars570
Forks126
Last commit2 years ago
ZSON
ZSONC

A PostgreSQL extension that compresses JSONB data using a shared dictionary of frequent strings, saving disk space and memory.

#storage-efficiency#jsonb#extensions
Stars569
Forks22
Last commit3 years ago
datanymizer
datanymizerRust

A powerful, Rust-based database anonymizer that generates native SQL dumps with flexible transformation rules.

#sql-dump#hacktoberfest#database
Stars566
Forks30
Last commit2 months ago
pg_back
pg_backGo

A PostgreSQL backup tool that dumps databases, globals, and configuration in flexible formats with encryption and cloud upload support.

#database-backup#devops#data-protection
Stars562
Forks60
Last commit7 days ago
Async flavor
Async flavorPython

A production-ready FastAPI CRUD API example with async/await, PostgreSQL, and comprehensive Pytest testing.

#fastapi#async-postgres#pytest
Stars562
Forks89
Last commit2 years ago
pg.zig
pg.zigZig

A native PostgreSQL driver for Zig with connection pooling, prepared statements, and LISTEN/NOTIFY support.

#database-driver#zig-package#connection-pooling
Stars559
Forks58
Last commit6 days ago
planter
planterGo

Generate PlantUML ER diagram textual descriptions from existing PostgreSQL database tables.

#schema-visualization#entity-relationship#cli-tool
Stars557
Forks52
Last commit2 years ago
FastAPI Example
FastAPI ExamplePython

A high-performance async REST API template built with FastAPI, GINO, Arq, and Uvicorn, powered by PostgreSQL and Redis.

#fastapi#uvicorn#orm
Stars554
Forks47
Last commit3 years ago
postgresDBSamples
postgresDBSamplesPLpgSQL

A collection of sample databases for PostgreSQL including AdventureWorks, Chinook, Pagila, and other realistic datasets.

#database#database-schema#database-examples
Stars553
Forks221
Last commit2 years ago
Graphweaver
GraphweaverTypeScript

A code-first, maximally customizable open-source alternative to Hasura that turns multiple data sources into a single GraphQL API.

#code-first#rest-api#api-unification
Stars550
Forks32
Last commit7 days ago
DFIRTrack
DFIRTrackPython

A system-focused web application for tracking systems, tasks, and artifacts during major digital forensics and incident response (DFIR) investigations.

#digital-forensics#incident-response-tooling#security-tooling
Stars535
Forks87
Last commit
nessie
nessieTypeScript

A modular Deno library for PostgreSQL, MySQL, MariaDB, and SQLite database migrations.

#deno-postgres#devops#postgres
Stars520
Forks31
Last commit2 years ago
Dapper.FastCRUD
Dapper.FastCRUDC#

A fast, type-safe .NET ORM built on Dapper that provides clean, maintainable SQL with C# 6/VB 14 language features.

#orm#database#dapper
Stars519
Forks130
Last commit2 years ago
asyncpgsa
asyncpgsaPython

A Python wrapper around asyncpg that provides SQLAlchemy Core support for asynchronous PostgreSQL database operations.

#database-driver#asyncio#postgres
Stars510
Forks46
Last commit2 years ago
tilex
tilexElixir

An open-source Elixir application for sharing daily learnings with a 200-word limit per post.

#ueberauth#hacktoberfest#elixir
Stars507
Forks114
Last commit7 months ago
triplex
triplexElixir

A simple and effective Elixir library for building multitenant applications using Ecto and database schemas.

#database#elixir#ecto
Stars506
Forks59
Last commit1 year ago
Kangaroo
KangarooTSQL

An AI-powered SQL client and database admin tool for multiple databases, focusing on comfort, fun, and developer friendliness.

#visual-sql-builder#database#redis
Stars504
Forks36
Last commit9 days ago
Ruckusing
RuckusingPHP

A PHP framework for database migrations inspired by ActiveRecord, supporting MySQL, PostgreSQL, and SQLite.

#version-control#cli-tool#database-migrations
Stars502
Forks97
Last commit1 year ago
TimescaleDB Tune
TimescaleDB TuneGo

A tool for tuning TimescaleDB performance by adjusting PostgreSQL settings to match your system's CPU and memory resources.

#automated-tools#performance-optimization#timescaledb
Stars501
Forks49
Last commit13 days ago
Database Design
Database DesignGo

A practical guide and decision reference for designing robust database schemas, focusing on PostgreSQL and MySQL for startups.

#backend-development#database#design
Stars500
Forks46
Last commit9 months ago
aqo
aqoC

A PostgreSQL extension that uses machine learning to improve query cardinality estimation and optimize execution plans.

#sql-optimizer#database-performance#execution-plan
Stars495
Forks57
Last commit22 days ago
VoucherVault
VoucherVaultHTML

A Django web application for digitally storing and managing vouchers, coupons, loyalty cards, and gift cards with PWA support.

#coupons#progressive-web-app#offline-first
Stars491
Forks22
Last commit3 days ago
OpenRecord
OpenRecordJavaScript

An ActiveRecord-inspired ORM for Node.js supporting SQLite3, MySQL, Postgres, Oracle, REST, and LDAP.

#orm#database#rest
Stars486
Forks38
Last commit5 years ago
Gavel
GavelPython

A web-based judging system for hackathons and project expos that uses pairwise comparisons to rank projects fairly.

#open-source#flask#hackathon-tools
Stars485
Forks268
Last commit3 months ago
LeagueStats
LeagueStatsVue

A web application providing comprehensive global statistics for League of Legends summoners.

#adonisjs#hacktoberfest#redis
Stars484
Forks70
Last commit3 months ago
cqrs
cqrsRust

A lightweight, opinionated CQRS and event sourcing framework for serverless architectures.

#event-driven-architecture#cqrs#serverless
Stars480
Forks61
Last commit3 days ago
Ekylibre
EkylibreRuby

An open-source farm management information system (FMIS) web application for connecting farms to the world.

#postgis#farm-management#agribusiness
Stars479
Forks170
Last commit2 days ago
temps
tempsRust

An open-source, self-hosted deployment platform that replaces Vercel and other SaaS tools with a single binary.

#devops#open-source#deployment-platform
Stars468
Forks25
Last commit1 day ago
Piccolo Admin
Piccolo AdminPython

A powerful, modern admin interface and CMS for Python, built on Piccolo ORM with Vue.js frontend.

#fastapi#admin-interface#vue-js
Stars467
Forks47
Last commit3 months ago
PreviousPage 12 of 20Next

Related Tags

Community-curated · Updated weekly · 100% open source

Found a gem we're missing?

Open-Awesome is built by the community, for the community. Submit a project, suggest an awesome list, or help improve the catalog on GitHub.

Submit a projectStar on GitHub
4 months ago
#Mysql224
#Database199
#Sql147
#Sqlite137
#Self Hosted128
#Docker115
#Postgres107
#Go92
#Orm84
#Devops73
#Golang63
#Python50