PostgreSQL
10 production projects and 13 rule sets built with PostgreSQL.
AGENTS.md Rules & Agent Skills
Django + PostgreSQL + Redis + Celery
Production guidelines for Django 5 enterprise applications, PostgreSQL connection pooling, Redis caching, and Celery async workers.
FastAPI + Python + PostgreSQL (Async SQLAlchemy & Pydantic v2)
Production guidelines for FastAPI, Pydantic v2 validation, Async SQLAlchemy 2.0 (asyncpg), Alembic migrations, and PostgreSQL/Redis.
Go + PostgreSQL (pgx & sqlc) + React
High-throughput systems architecture rules for Go (Golang), pgxpool connection management, sqlc type-safe query generation, and React web dashboards.
Laravel + Livewire + PostgreSQL
Production guidelines for Laravel 11 monoliths, Livewire reactive components, Eloquent ORM query discipline, and queued job workers.
NestJS + PostgreSQL + Redis + BullMQ
Enterprise backend architecture guidelines for NestJS modular design, PostgreSQL connection pooling, Redis BullMQ background jobs, and DTO validation.
Next.js 15 + Drizzle ORM + Supabase
Production guidelines for Next.js App Router, Drizzle ORM with postgres-js, Supabase Transaction Pooler (prepare: false), and RLS security.
Next.js + ClickHouse + Prisma (Analytics & Observability)
Architecture guidelines for high-volume event ingestion and analytical queries using ClickHouse alongside a PostgreSQL/Prisma control plane.
Next.js 15 + Prisma ORM + PostgreSQL
Production guidelines for Next.js App Router, Server Actions, Prisma connection pooling, PgBouncer/Neon tuning, and Zod schema validation.
Nuxt 3 + Vue + PostgreSQL
Production guidelines for Nuxt 3 server routes and universal rendering, Vue 3 Composition API, and PostgreSQL via a typed query layer.
Elixir + Phoenix LiveView + PostgreSQL
Real-time reactive web architecture for Elixir 1.17, Phoenix 1.7+, LiveView HTML-over-WebSockets, OTP supervision trees, and Ecto.
Ruby on Rails + PostgreSQL + Redis + Sidekiq
Production guidelines for Ruby on Rails monoliths, ActiveRecord pool tuning, Redis Sidekiq background jobs, and modern Hotwire or React UI architecture.
Rust + Axum + PostgreSQL (sqlx & Tokio)
High-concurrency systems architecture for Rust 2024, Axum 0.8, Tokio async runtime, compile-time SQL verification with sqlx, and Tower middleware.
SvelteKit + PostgreSQL + Drizzle ORM
Production guidelines for SvelteKit form actions and load functions, Drizzle ORM over PostgreSQL, and Svelte 5 runes-based reactivity.
Production Projects
Vaultwarden
Unofficial Bitwarden compatible server written in Rust; replaces the heavy multi-container C#/.NET stack with a lightweight single-binary service consuming under 50MB of RAM.
Nextcloud
The world's most deployed self-hosted cloud office suite; gives complete data sovereignty over files, calendars, office collaboration, and communications without third-party surveillance.
Hasura
Turns databases into high-throughput GraphQL APIs in seconds; compiles GraphQL queries directly into optimized single-query SQL statements in Haskell with enterprise access controls.
Payload CMS
The modern standard for headless content management; runs completely natively inside Next.js with Drizzle ORM and React Server Components, offering zero-latency Local API calls.
Prisma
Benchmark developer experience for relational databases; leverages declarative schema modeling to auto-generate fully type-safe TypeScript clients backed by an optimized query engine.
Gitea
Frictionless GitHub alternative; written in Go to run on minimal hardware (even a Raspberry Pi) while providing Git repository management, issue tracking, and Docker-based CI/CD pipelines.
n8n
Leading self-hosted Zapier alternative; combines an intuitive Vue visual canvas with a high-throughput Node.js execution engine and built-in AI agent reasoning nodes.
Apache Answer
Self-hosted developer community and technical Q&A platform (Stack Overflow / Dev Community alternative). Built with Go Gin for high concurrency and low memory usage, GORM for multi-database persistence (Postgres/MySQL/SQLite), and React TypeScript for rich Markdown editing.
GlitchTip
Lightweight Sentry-compatible application performance monitoring and error tracking platform. Built on Python Django and PostgreSQL with async Celery task queues for high-volume exception ingestion and Redis message buffering.
Temporal
Durable execution platform allowing developers to write resilient, long-running distributed workflows in code without worrying about network partitions, crashes, or server restarts. Backed by Go gRPC cluster nodes and persistent event-history replay logs in PostgreSQL/Cassandra.
Often Used With
Frequently Asked Questions
How many production projects use PostgreSQL?
10 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 Docker, TypeScript, SQLite.
Is there an AGENTS.md rule or Claude Code skill for PostgreSQL?
Yes — Django + PostgreSQL + Redis + Celery, FastAPI + Python + PostgreSQL (Async SQLAlchemy & Pydantic v2), Go + PostgreSQL (pgx & sqlc) + React, Laravel + Livewire + PostgreSQL, NestJS + PostgreSQL + Redis + BullMQ, Next.js 15 + Drizzle ORM + Supabase, Next.js + ClickHouse + Prisma (Analytics & Observability), Next.js 15 + Prisma ORM + PostgreSQL, Nuxt 3 + Vue + PostgreSQL, Elixir + Phoenix LiveView + PostgreSQL, Ruby on Rails + PostgreSQL + Redis + Sidekiq, Rust + Axum + PostgreSQL (sqlx & Tokio), SvelteKit + PostgreSQL + Drizzle ORM each include a full AGENTS.md, CLAUDE.md, Cursor .mdc rule set and an installable SKILL.md covering PostgreSQL.