# postgresql

TypeScript ORM that feels like SQL

Lightweight, serverless-ready TypeScript ORM with zero dependencies bringing SQL-like syntax into TypeScript for maximum type-safety. Maps queries closely to raw SQL with full auto-completion and type inference. Features Drizzle Kit for migrations, Drizzle Studio for visual browsing, supports PostgreSQL, MySQL, SQLite, and Turso. Runs on Node.js, Bun, Deno, Cloudflare Workers, and Vercel Edge. 26K+ GitHub stars, growing fast as a Prisma alternative.

Batteries-included full-stack framework for React, Node.js, and Prisma

Wasp is an open-source full-stack web framework that brings the Rails-like batteries-included experience to the JavaScript ecosystem. It uses a declarative configuration file to define auth, database models, server operations, and routing, then compiles to a standard React and Node.js application with Prisma for data access. With 18,000+ GitHub stars and YC backing, Wasp eliminates boilerplate while giving AI coding agents clear structure and guardrails.

Git for data — version-controlled SQL database with branch, merge, and diff

Dolt is a SQL database that implements Git-style version control directly on your data. Every write creates a commit, and you can branch, merge, diff, and revert tables just like source code. It speaks the MySQL wire protocol so existing MySQL clients, ORMs, and tools work out of the box. Dolt is used for AI training data management, reproducible analytics, collaborative data editing, and agent memory stores.

Next-generation Node.js ORM

Next-generation TypeScript ORM with schema-first design and auto-generated, type-safe database client. Define models in Prisma Schema Language, manage migrations via Prisma Migrate, and browse data in Prisma Studio. Supports PostgreSQL, MySQL, SQLite, SQL Server, MongoDB, and CockroachDB. Prisma Accelerate provides edge caching and connection pooling, Optimize offers AI-powered query analysis. 40K+ GitHub stars, widely adopted in Node.js/TypeScript.

Database schema management for modern teams

Database schema management and migration tool by Ariga with a declarative schema-as-code approach. Features automatic migration planning, CI/CD integration, and drift detection to keep database schemas in sync across environments. Supports PostgreSQL, MySQL, MariaDB, and SQLite, making database changes as reviewable and version-controlled as application code.

Serverless database with search and AI built-in

Serverless database platform that combines Postgres, full-text search, analytics, and AI features in a single service. Built-in vector search for AI applications, branching for safe schema changes, and a spreadsheet-like UI for data exploration. Designed for developers who want powerful database capabilities without managing separate services for search, analytics, and embeddings.

Modern PostgreSQL client for Mac

Native macOS client for PostgreSQL with a clean, intuitive interface designed for simplicity. Features a visual table editor for inline data editing, SQL query editor with syntax highlighting, table structure inspector, favorites for saved queries, and SSH tunnel support. Known for its polished Apple-native UI and ease of use compared to heavier tools. Ideal for developers and designers who need quick PostgreSQL access without enterprise complexity.

Promise-based Node.js ORM

Mature, promise-based ORM for Node.js supporting PostgreSQL, MySQL, MariaDB, SQLite, and SQL Server. Features model definitions with validations, eager/lazy loading, transactions, migrations, raw queries, and lifecycle hooks. Supports soft deletes, scopes, and virtual fields. One of the oldest and most battle-tested Node.js ORMs, widely used in enterprise apps though increasingly succeeded by Prisma and Drizzle in new projects.

Open-source SQL editor and DB manager

Self-hosting platform for deploying applications, databases, and services on your own infrastructure. Open-source Heroku and Vercel alternative with Docker-based deployments, automatic SSL, and built-in monitoring. Gives developers full control over their hosting environment with a modern UI, reducing cloud costs while maintaining the convenience of managed platform features.

JetBrains database IDE

JetBrains' professional database IDE with intelligent SQL assistance, schema navigation, data editor, and admin tools for PostgreSQL, MySQL, Oracle, SQL Server, MongoDB, Redis, and more. Features context-aware completion, error detection, explain plan visualization, data export, and version control for schema changes. Part of JetBrains All Products pack or standalone. The premium choice for database development.

PostgreSQL administration tool

The most popular open-source administration and management tool for PostgreSQL, used by millions of DBAs and developers worldwide. Features a powerful SQL query editor with auto-completion, visual query builder (graphical EXPLAIN), server dashboard with real-time monitoring, backup/restore wizards, ERD generator for schema visualization, and user/role management. Runs as a web application accessible via browser. Supports PostgreSQL 12+ and is available on Windows, macOS, Linux, and Docker.

Universal database tool

Cloud platform for deploying full-stack applications with zero configuration. Instant deploys from GitHub with automatic scaling, preview deployments, and built-in analytics. Originally the creators of Next.js, Vercel excels at frontend and edge deployments with a global CDN, serverless functions, and seamless integration with modern JavaScript frameworks.

Modern database management GUI

Native database management GUI for macOS, Windows, and Linux that provides a fast, clean interface for working with PostgreSQL, MySQL, SQLite, SQL Server, Redis, CockroachDB, and more. Features an intuitive query editor with auto-completion, visual table editor for inline data editing, import/export in multiple formats, SSH tunnel support, and connection management. Known for its speed and polished UI compared to heavier tools like DBeaver. Popular among Mac developers.

ORM for TypeScript and JavaScript

Full-featured ORM for TypeScript and JavaScript supporting Active Record and Data Mapper patterns. Works with PostgreSQL, MySQL, MariaDB, SQLite, Oracle, SQL Server, and MongoDB. Features decorator-based entity definitions, migrations, relations (one-to-one, many-to-many), lazy/eager loading, query builder, transactions, and caching. Supports both Node.js and browser runtimes. 34K+ GitHub stars. Mature but losing mindshare to Prisma and Drizzle for new TypeScript projects.

SQL query builder for Node.js

Flexible SQL query builder for Node.js supporting PostgreSQL, MySQL, SQLite, Oracle, and MSSQL. Chainable API for constructing queries with parameterized bindings. Features schema builder, migration system, seed files, transaction support, and connection pooling. Foundation for ORMs like Bookshelf.js and Objection.js. One of the most established query builders in the Node.js ecosystem.

Type-safe SQL query builder for TS

Type-safe SQL query builder for TypeScript that provides auto-completion and compile-time type checking without the abstraction overhead of a traditional ORM. Write queries that map directly to SQL while getting full TypeScript inference from your database schema. Supports PostgreSQL, MySQL, and SQLite with migrations, transactions, and raw SQL escape hatches. Lightweight with zero dependencies. Ideal for developers who want SQL control with TypeScript safety. Growing Knex.js alternative.

Serverless Postgres

Serverless Postgres platform that separates storage and compute for instant scaling, branching, and auto-suspend. Features database branching (like Git for databases) for development and preview environments, autoscaling compute that scales to zero when idle, point-in-time restore, and a generous free tier. Compatible with any PostgreSQL client and supports extensions like pgvector for AI embeddings. Growing as the database layer for Vercel, Replit, and modern serverless stacks.

The open-source Firebase alternative

Open-source Firebase alternative providing a full backend-as-a-service on PostgreSQL. Auto-generated REST and GraphQL APIs from your schema, real-time subscriptions, built-in auth with 20+ social providers and Row Level Security, S3-compatible file storage with CDN, and Deno-powered Edge Functions. Visual dashboard with SQL editor and table editor. Supports pgvector for AI apps. Self-hostable or managed with a generous free tier. 75K+ GitHub stars.

Cloud infrastructure for developers

Cloud infrastructure provider offering Droplets (VMs), managed Kubernetes, app platform PaaS, managed databases (PostgreSQL, MySQL, Redis, MongoDB), Spaces (object storage), serverless functions, and a CDN. Known for developer-friendly docs, simple pricing from $4/month, and a clean API/CLI. Popular with startups and indie devs as a simpler AWS alternative. 1-click marketplace apps and extensive community tutorials.

Cloud for the new default

Unified cloud platform for deploying web services, static sites, background workers, cron jobs, and managed databases with automatic scaling and zero DevOps. Auto-deploy from Git with preview environments, built-in DDoS protection, free TLS, and global CDN. Native runtimes for Node.js, Python, Go, Rust, Ruby, Elixir plus Docker. Managed PostgreSQL and Redis with daily backups, private networking, and infrastructure-as-code via Blueprints. Modern Heroku alternative with a free tier.

Infrastructure, instantly

Modern cloud platform for deploying full-stack apps, databases, and workers with instant provisioning and usage-based pricing. Deploy from GitHub or CLI with zero config for Node.js, Python, Go, Rust, and Docker. Built-in PostgreSQL, MySQL, Redis, and MongoDB with auto backups. Features private networking, environment management, cron jobs, TCP proxying, and real-time logs. Popular with indie hackers and startups for fast MVPs with a generous free trial including $5 monthly credits.