data · database
Filter in Explore PostgreSQL
69 production projects and 18 rule sets built with PostgreSQL.
Production projects
- Self-Hosted Real-Time Push Server Classic Gotify Gotify keeps the server one deployable Go binary by embedding its Vite/React web UI, using Gin and gorilla/websocket for the REST and streaming API, and swapping SQLite, MySQL or PostgreSQL through GORM, while a compiled Go plugin system handles extensibility instead of a scripting layer.
- Monitoring & Observability Dashboard Classic Grafana Grafana splits its backend into a growing set of independently versioned Go modules under apps/, tied together by a go.work workspace and modeled with Kubernetes-style APIs (pkg/apiserver, CUE-defined kinds), so individual product areas like alerting or dashboards can evolve without one monolithic backend module.
- Agentic Development Environment for Parallel Coding Agents Hybrid Orca Agent CLIs stay the user's own. Orca adds the orchestration layer around them: isolated git worktrees, a PTY daemon that outlives the UI, and a relay for mobile steering. It can support new agents without bundling them.
- Team Collaboration Suite Classic Mattermost A single Go binary keeps the API, scheduler, and websocket hub in one deployable process backed by a required PostgreSQL database, while optional Redis, Elasticsearch, and OpenSearch clients let larger deployments add caching and full-text search without changing the core architecture.
- Developer Tool Classic Supabase Studio Centering the developer experience around PostgreSQL allows Supabase Studio to provide spreadsheet-like table editing and SQL execution directly on production databases.
- Scheduling SaaS Classic Cal.com Splitting the tRPC-based web app from an independently versioned NestJS Platform API lets Cal.com serve both its own product and third-party developers from one monorepo, while Turborepo and per-integration app-store packages keep dozens of calendar/payment providers buildable and testable in isolation.
- Federated Link Aggregator & Forum Classic Lemmy Lemmy splits its Rust backend into many small crates (per database view, API, ActivityPub, email) over one PostgreSQL schema with heavy migrations, so federation, the local API and queries evolve separately while a single binary serves an instance.
- Shell History Sync Classic Atuin Atuin keeps history local in SQLite and encrypts it before sync, so the Axum sync server stays a thin store; a gRPC daemon and capability crates (CLI, server, AI, dotfiles) let each part evolve behind feature flags.
- Rails-Style Rust Web Framework Classic Loco Loco assembles proven crates (Axum, SeaORM, Tera, Lettre, OpenDAL) behind Rails-style conventions and generators, uses feature flags to keep infrastructure optional, and ships an AGENTS.md, an agent skill and evals so agents can build on it.
- Package Registry Classic crates.io crates.io runs one pinned-dependency Rust binary as migrate, web and worker processes, splits domains into small internal crates, and generates its TypeScript client from OpenAPI types so the SvelteKit frontend and Axum API share one contract.
- Open-Source Payments Orchestration Classic Hyperswitch Hyperswitch runs a panic-averse Rust router on Actix Web with Redis absorbing hot writes and a drainer persisting them to PostgreSQL, while a routing DSL that also compiles to WebAssembly keeps processor selection consistent between server and browser.
- Multi-Agent Interactive AI Classroom Classic OpenMAIC Built as a Next.js app around a set of npm-published packages (slide DSL, generation, renderer, editor, importer, storage). The multi-agent LangGraph pipeline, the slide format and persistence can each be reused or swapped, and heavy video rendering runs in a separate container.
- LLM Knowledge Base & RAG Platform Classic WeKnora Retrieval, agents and the API sit in one Go service, and parsing is delegated to a Python gRPC service. Storage backends are pluggable, so the same codebase runs as a lite SQLite binary or a full Kubernetes deployment on existing Postgres, Elasticsearch or vector databases.
- Open-Source SEO Research Platform Hybrid OpenSEO Running on Cloudflare Workers with D1, Workflows and Durable Objects makes it free-tier friendly to self-host and to scale when hosted. Supporting both D1 and Postgres through Drizzle, plus a Docker path, keeps the project portable beyond Cloudflare.
- Lightweight Self-Hosted Password Vault Classic Vaultwarden Vaultwarden replaces the heavy, multi-container official Bitwarden stack with a single fast Rust executable consuming minimal RAM.
- Self-Hosted Collaborative Productivity Suite Classic Nextcloud Server internals (OC) are kept separate from a versioned public API (OCP) so that independently namespaced apps under apps/ can extend Nextcloud without depending on private implementation details, while database support is validated per-engine in CI.
- Instant GraphQL Engine & Unified Data Access Classic Hasura Hasura runs two independently evolving query engines from one repository — a Haskell V2 server and a Rust V3 engine — and extends database support through an out-of-process Data Connector protocol, so a new database backend plugs in as a separate agent instead of new code inside either engine.
- Next.js-Native Headless CMS & App Framework Hybrid Payload CMS A pnpm and Turborepo monorepo lets one core package share a common database-adapter export shape across MongoDB, Postgres, SQLite, and D1, while GraphQL, storage providers, and deployment templates stay in separate packages so a project only pulls in the pieces its target host and database actually need.
- Next-Generation Node.js & TypeScript ORM Classic Prisma Declarative schema modeling combined with modular driver adapters allows Prisma to generate fully type-safe database clients that run consistently from Node servers to edge runtimes.
- Lightweight Self-Hosted Git Service Classic Gitea One Go process fronted by XORM abstracts four relational databases and pluggable search/storage backends, so the same codebase scales from a single SQLite file on a Raspberry Pi to a MySQL- or PostgreSQL-backed team instance.
- Fair-Code Workflow Automation & AI Integrator Hybrid n8n n8n splits its execution engine, workflow schema, and integration nodes into separate TypeORM- and Express-backed packages so the automation runtime, node library, and Vue editor can be built, tested, and versioned independently inside one Turborepo-orchestrated pnpm workspace.
- Automated GraphQL API Engine Classic PostGraphile Synthesizing GraphQL APIs directly from PostgreSQL catalogs eliminates manual resolver boilerplate while Grafast planning solves N+1 query overhead at the database layer.
- Authentication & SSO Proxy Companion Classic Authelia A single fasthttp-based Go binary keeps the authentication portal, OIDC provider, and MFA logic in one process with pluggable SQLite/MySQL/PostgreSQL storage, so it can run as a zero-dependency single instance or scale out with a shared database.
- Time-Series SQL Database Classic QuestDB Combining a zero-GC Java engine with C++/Rust vector acceleration gives QuestDB ultra-low latency ingestion and microsecond SQL queries over billions of metrics.
Often used with PostgreSQL
AGENTS.md rules and agent skills with PostgreSQL
django-postgres-redis/AGENTS.mdDjango + PostgreSQL + Redis + CeleryProduction guidelines for Django 6 enterprise applications, PostgreSQL connection pooling, Redis caching, and Celery async workers. intermediatefastapi-jev-decision-service/AGENTS.mdFastAPI + Jev Decision Service (Python)Python rules for a Jev decision service: FastAPI, the async typesafe-sdk client, a typed question registry, confidence thresholds, decision logs and replay tests. intermediatefastapi-python-postgres/AGENTS.mdFastAPI + Python + PostgreSQL (Async SQLAlchemy & Pydantic v2)Production guidelines for FastAPI, Pydantic v2 validation, Async SQLAlchemy 2.0 (asyncpg), Alembic migrations, and PostgreSQL/Redis. intermediatego-postgres-react/AGENTS.mdGo + PostgreSQL (pgx & sqlc) + ReactHigh-throughput systems architecture rules for Go (Golang), pgxpool connection management, sqlc type-safe query generation, and React web dashboards. advancednestjs-postgres-redis/AGENTS.mdNestJS + PostgreSQL + Redis + BullMQEnterprise backend architecture guidelines for NestJS modular design, PostgreSQL connection pooling, Redis BullMQ background jobs, and DTO validation. intermediatenextjs-ai-sdk-jev/AGENTS.mdNext.js + Vercel AI SDK + Jev (System One + LLM)Next.js rules for Jev: typed TypeSafe decisions route, classify and gate on the server, the Vercel AI SDK streams LLM text, and confidence decides what runs. intermediatenextjs-clickhouse-analytics/AGENTS.mdNext.js + ClickHouse + Prisma (Analytics & Observability)Architecture guidelines for high-volume event ingestion and analytical queries using ClickHouse alongside a PostgreSQL/Prisma control plane. advancedlaravel-livewire-postgres/AGENTS.mdLaravel + Livewire + PostgreSQLProduction guidelines for Laravel 13 monoliths, Livewire reactive components, Eloquent ORM query discipline, and queued job workers. intermediatenextjs-drizzle-supabase/AGENTS.mdNext.js 16 + Drizzle ORM + SupabaseProduction guidelines for Next.js App Router, Drizzle ORM with postgres-js, Supabase Transaction Pooler (prepare: false), and RLS security. starternextjs-prisma-postgres/AGENTS.mdNext.js 16 + Prisma ORM + PostgreSQLProduction guidelines for Next.js App Router, Server Actions, Prisma connection pooling, PgBouncer/Neon tuning, and Zod schema validation. starterphoenix-liveview-postgres/AGENTS.mdElixir + Phoenix LiveView + PostgreSQLReal-time reactive web architecture for Elixir 1.20, Phoenix 1.8+, LiveView HTML-over-WebSockets, OTP supervision trees, and Ecto. advancednuxt-vue-postgres/AGENTS.mdNuxt 4 + Vue + PostgreSQLProduction guidelines for Nuxt 4 server routes and universal rendering, Vue 3 Composition API, and PostgreSQL via a typed query layer. starterrust-axum-htmx-askama/AGENTS.mdRust + Axum + htmx + Askama (Server-Rendered Web App)Server-rendered Rust web app rules: Axum 0.8, compile-time Askama templates, htmx partials, sqlx 0.9 + PostgreSQL, and a cargo check loop for AI agents. intermediaterust-axum-postgres/AGENTS.mdRust + Axum + PostgreSQL API (sqlx & Tokio)Rust API and backend rules: Axum 0.8 on Tokio, compile-time SQL checks with sqlx 0.9, Tower middleware, typed errors and a cargo check loop for AI agents. advancedrust-leptos-fullstack/AGENTS.mdLeptos Full-Stack Rust (SSR + Hydration on Axum)Full-stack Rust web app rules: Leptos 0.8 SSR with hydration, server functions on Axum, sqlx + PostgreSQL, cargo-leptos and Tailwind, written for AI agents. advancedrust-loco-saas/AGENTS.mdLoco + SeaORM + PostgreSQL (Rails-Style Rust SaaS)Rails-style Rust SaaS rules for Loco: generators, SeaORM models and migrations, Tera views or htmx scaffolds, JWT auth, background workers and mailers. intermediatesveltekit-postgres-drizzle/AGENTS.mdSvelteKit + PostgreSQL + Drizzle ORMProduction guidelines for SvelteKit form actions and load functions, Drizzle ORM over PostgreSQL, and Svelte 5 runes-based reactivity. starterrails-postgres-redis/AGENTS.mdRuby on Rails + PostgreSQL + Redis + SidekiqProduction guidelines for Ruby on Rails monoliths, ActiveRecord pool tuning, Redis Sidekiq background jobs, and modern Hotwire or React UI architecture. intermediate
Questions about PostgreSQL
How many production projects use PostgreSQL?
69 verified production projects in the STACK IT FAST directory use PostgreSQL, each with a full architecture breakdown.
What is PostgreSQL most often used with?
Across projects in the directory, PostgreSQL is most commonly paired with TypeScript, Docker, Redis.
Is there an AGENTS.md rule or Claude Code skill for PostgreSQL?
Yes — Django + PostgreSQL + Redis + Celery, FastAPI + Jev Decision Service (Python), FastAPI + Python + PostgreSQL (Async SQLAlchemy & Pydantic v2), Go + PostgreSQL (pgx & sqlc) + React, NestJS + PostgreSQL + Redis + BullMQ, Next.js + Vercel AI SDK + Jev (System One + LLM), Next.js + ClickHouse + Prisma (Analytics & Observability), Laravel + Livewire + PostgreSQL, Next.js 16 + Drizzle ORM + Supabase, Next.js 16 + Prisma ORM + PostgreSQL, Elixir + Phoenix LiveView + PostgreSQL, Nuxt 4 + Vue + PostgreSQL, Rust + Axum + htmx + Askama (Server-Rendered Web App), Rust + Axum + PostgreSQL API (sqlx & Tokio), Leptos Full-Stack Rust (SSR + Hydration on Axum), Loco + SeaORM + PostgreSQL (Rails-Style Rust SaaS), SvelteKit + PostgreSQL + Drizzle ORM, Ruby on Rails + PostgreSQL + Redis + Sidekiq each include a full AGENTS.md, CLAUDE.md, Cursor .mdc rule set and an installable SKILL.md covering PostgreSQL.