Prisma ORM

Drizzle ORM is a lightweight TypeScript ORM for defining database schemas and querying relational databases. Its migration tooling can generate, apply, push, pull, export, and check schema migrations; the documentation covers PostgreSQL, MySQL, SQLite, SingleStore, MSSQL, CockroachDB, and related database services. In the cited context, Drizzle owns the PostgreSQL schema and migration workflow for effect-mq.

PostgreSQL is an open-source relational database management system maintained by the PostgreSQL Global Development Group. It provides SQL-compliant, ACID transactions, MVCC concurrency, and extensibility through custom types, functions and extensions, and is used for general-purpose and enterprise database workloads.

PortalJS is an open-source, AI-native framework maintained by Datopian and its community for building data portals. Its agentic skills advise on storage, compute, catalog, access, hosting, and metadata, then scaffold the result as plain, editable Next.js code. Claude Code skills can create a portal, add CSV or JSON datasets, connect to backends such as CKAN, and deploy it; generated portals include a home page, catalog, and dataset showcase, with support for configurable data providers, charts, maps, and schemas. A bare template is also available without the AI skills, and the project presents Git, object storage, Parquet, and DuckDB as an optional modern architecture while retaining traditional datastores as supported choices.

Wasp (Web Application Specification) is an open-source, Rails-like full-stack framework for React, Node.js, and Prisma. Developers describe an application's high-level structure in a declarative `main.wasp.ts` specification and implement custom logic in React, Node.js, and Prisma files; the Wasp compiler then generates the frontend, backend, and deployment source. Built-in features include authentication, client-server RPC, background jobs, email sending, end-to-end type safety, and single-command deployment. Its high-level specification is designed to give AI coding agents clear application structure and guardrails, while generated applications can be deployed without provider lock-in.

Supabase is a hosted Postgres development platform for building production web, mobile, and AI applications, built from open-source components and available for self-hosting or local development. It provides a managed Postgres database, authentication and authorization, Row Level Security, auto-generated REST and GraphQL APIs, realtime database-change subscriptions over WebSockets, Edge Functions and serverless database functions, file storage, and an AI vector and embeddings toolkit. Its architecture combines PostgreSQL with services including PostgREST for REST APIs, GoTrue for JWT-based authentication and session management, Realtime for converting PostgreSQL replication changes to JSON broadcasts, Storage for S3-compatible file management with Postgres permissions, and pg_graphql for GraphQL access. It also provides dashboard tools such as table and SQL editors, policy management, deployment workflows, and official client libraries for JavaScript, Flutter, Swift, and Python, with additional community libraries for other languages.