llms.txt
Compare with other sites' llms.txt files →# Constructive
> Constructive delivers secure-by-default Postgres with structured row-level security, multi-tenancy, and AI-native infrastructure—built for enterprise precision.
## Courses
### Quickstart: Getting Up and Running
- [Prerequisites](https://constructive.io/learn/quickstart/prerequisites.md): Set up Node.js, Postgres, and pgpm. Everything you need to get started with modular database development.
- [Spinning Up a Modular Database in 2 Minutes](https://constructive.io/learn/quickstart/spinning-up-modular-postgres.md): Experience the power of modular databases by installing a pre-built module and deploying it to Postgres—no SQL writing required.
### Modular Postgres Development with Database Packages
- [pgpm Workspaces: A New Way to Organize Postgres Projects](https://constructive.io/learn/modular-postgres/workspaces-organize-postgres.md): Understand how pgpm workspaces bring npm-style modularity to Postgres development.
- [Initializing a Workspace for Modular Postgres Development](https://constructive.io/learn/modular-postgres/initializing-workspace.md): Set up your first pgpm workspace with proper configuration and structure.
- [Creating Your First Postgres Database Module](https://constructive.io/learn/modular-postgres/creating-first-module.md): Build your first database module with deploy, revert, and verify scripts.
- [Testing Your Database Module](https://constructive.io/learn/modular-postgres/testing-your-module.md): Write and run tests for your database module with watch mode for rapid feedback.
- [Managing Database Package Dependencies in a Workspace](https://constructive.io/learn/modular-postgres/managing-dependencies.md): Master module dependencies, cross-module references, and automatic dependency resolution.
### Authoring Database Changes
- [Adding Your First Database Change](https://constructive.io/learn/authoring-database-changes/adding-your-first-database-change.md): Learn the fundamental workflow for adding database changes using the pgpm add command and the three-file pattern for safe, reversible migrations.
- [Change Naming Conventions](https://constructive.io/learn/authoring-database-changes/organizing-database-changes-with-nested-paths.md): Structure migrations using nested paths for maintainable schemas.
- [Plan Files and Deployment Plans](https://constructive.io/learn/authoring-database-changes/plan-files-and-deployment-plans.md): Understand the plan file format and how pgpm generates deployment plans from SQL dependencies.
### End-to-End Postgres Testing with TypeScript
- [Spinning Up Temporary Testing Databases for Postgres](https://constructive.io/learn/e2e-postgres-testing/spinning-up-temporary-testing-databases.md): Create ephemeral Postgres databases for testing with pgsql-test. Fast, isolated, and automatically cleaned up.
- [How to Test Row-Level Security (RLS) in Postgres](https://constructive.io/learn/e2e-postgres-testing/testing-rls-policies.md): Test RLS policies by simulating different users and roles. Verify that your security policies actually work as intended.
- [Advanced RLS Testing Scenarios - Simulating Many Users and Roles](https://constructive.io/learn/e2e-postgres-testing/advanced-rls-testing-scenarios.md): Test complex multi-user scenarios by switching between users within tests. Master the savepoint pattern to handle exceptions and aborted transactions when testing operations that should fail.
- [Seeding Postgres Test Databases](https://constructive.io/learn/e2e-postgres-testing/seeding-test-databases.md): Learn how to seed test databases with realistic data using loadJson, loadSql, and loadCsv methods for comprehensive testing scenarios.
### End-to-End Postgres Testing with Supabase
- [Supabase Testing for the Modern Developer](https://constructive.io/learn/supabase/supabase-test.md): Introducing Supabase Test Suite: TypeScript-native testing for Supabase with isolated databases, RLS testing, and instant feedback loops.
- [Setting Up Local Supabase Database Testing](https://constructive.io/learn/supabase/setting-up-local-supabase-testing.md): Get started with supabase-test: install dependencies, configure local Supabase, and write your first isolated database test with automatic rollbacks.
- [Writing Your First Supabase Test in TypeScript](https://constructive.io/learn/supabase/writing-your-first-supabase-test-in-typescript.md): Create your first Supabase test with supabase-test's getConnections(), understand test isolation, and verify your setup with simple database queries.
- [Testing Row-Level Security Policies in Supabase](https://constructive.io/learn/supabase/testing-rls-policies-in-supabase.md): Test Supabase RLS policies by simulating authenticated users and anonymous access. Verify your security policies work as intended with supabase-test.
- [Seeding Supabase Test Databases](https://constructive.io/learn/supabase/seeding-supabase-test-databases.md): Learn how to seed Supabase test databases with auth.users, realistic data using loadJson, loadSql, and loadCsv methods for comprehensive testing.
- [Running Supabase Tests in GitHub Actions](https://constructive.io/learn/supabase/running-supabase-tests-in-github-actions.md): Set up GitHub Actions CI/CD pipeline to automatically test your Supabase database with every commit. Learn how to configure workflows, start Supabase, and run tests.
- [Troubleshooting Supabase Test](https://constructive.io/learn/supabase/supabase_troubleshooting.md): Automate Supabase testing in GitHub Actions: provision local Supabase stack, run tests in CI, and optimize for fast feedback loops.
### End-to-End Postgres Testing with Drizzle ORM
- [How to Setup Drizzle ORM for End-to-End Testing](https://constructive.io/learn/drizzle-testing/drizzle-orm-setup-and-basic-testing.md): Set up Drizzle ORM with drizzle-orm-test for Postgres testing. Create type-safe database queries with automatic test isolation.
- [Testing Row-Level Security with Drizzle ORM](https://constructive.io/learn/drizzle-testing/testing-rls-with-drizzle-orm.md): Test RLS policies with Drizzle ORM using automatic context management. Verify security policies with type-safe queries.
### End-to-End Postgres Testing with PGlite
- [How to Set Up PGlite for End-to-End Testing](https://constructive.io/learn/pglite-testing/pglite-setup-and-basic-testing.md): Set up pglite-test to run Postgres migrations and tests entirely in-process with PGlite—no server, no Docker, no services. Real migrations, transaction isolation, and instant CI.
- [Testing Row-Level Security and Extensions with PGlite](https://constructive.io/learn/pglite-testing/testing-rls-with-pglite.md): Test RLS policies in-process with PGlite by switching user contexts, wire up a WASM extension like pgvector, and run it all in services-free CI.
### Troubleshooting
- [Common Issues and Solutions](https://constructive.io/learn/troubleshooting/common-issues-and-solutions.md): Quick fixes for common pgpm, Postgres, and testing issues.
## Blog
- [Introducing Safegres: Secure Postgres, Verified on Every Change](https://constructive.io/blog/introducing-safegres.md): Safegres is an open-source verifier for secure Postgres: it checks who can reach which rows in a live database and catches security mistakes before they ship. We ran it on our own platform first and fixed more than 2,700 findings.
- [Your Next Database User Won't Be a Human](https://constructive.io/blog/your-next-database-user-wont-be-a-human.md): Recap of Frontier Research Club #26 at Pebblebed during a16z SF Tech Week, which Constructive co-hosted and sponsored. Zep and the UC Berkeley Sky Computing Lab on what changes when AI agents become users of production databases: memory that knows when it's stale, and data systems built for agents that speculate instead of query.
- [Painting with Light at Grace Cathedral](https://constructive.io/blog/adapting-the-awepad-for-the-rose-window.md): For five nights, Illuminate lit Grace Cathedral's Rose Window across Nob Hill, and anyone on the lawn could paint it with the AwePad.
- [PGlite + pgpm: End-to-End Postgres Testing in Your Test Runner](https://constructive.io/blog/pglite-testing.md): Run real Postgres migrations and tests entirely in-process with PGlite. No server, no Docker, no CI services—just install and test. Explore Constructive's new pglite-test library, reference suite, and hands-on tutorials for fast, secure, services-free Postgres testing.
- [Software for San Francisco](https://constructive.io/blog/software-for-the-city-of-awe.md): This summer Illuminate lit up San Francisco with WELCOME on Market Street and 7X7 at Civic Center. We donated our time to build the AwePad, the iPad app that lets anyone paint the lasers.
- [From Vibe Coding to Agentic Engineering](https://constructive.io/blog/from-vibe-coding-to-agentic-engineering.md): Notes from the May 1 panel at SVB Experience Center with DeepMind, Mastra, and Constructive. As AI drives the cost of code toward zero, the bottleneck shifts to trust — and the engineer's job is no longer writing code, it's designing systems that produce code we can rely on.
- [Putting Postgres in package.json](https://constructive.io/blog/postgresconf-2026-part-3-modularity.md): Part 3 of our PostgresConf 2026 series. Inside the second talk: pgpm, modular databases, and why test-driven database development is a survival requirement for AI-generated code.
- [When Trust Becomes Infrastructure: Secure-by-Default Postgres](https://constructive.io/blog/postgresconf-2026-part-2-security.md): Part 2 of our PostgresConf 2026 series. A recap of the keynote on why human code review can't keep up with AI-generated code—and why trust has to move down the stack into a secure-by-default database.
- [From Berkeley to AI: Reflections on PostgresConf 2026](https://constructive.io/blog/postgresconf-2026-part-1-community.md): Part 1 of our PostgresConf 2026 series. Sitting down with original Berkeley Postgres developers Greg Kemnitz and Curt Kolovson, and dbtune's Luigi Nardi, on how a forty-year-old database became the foundation for the AI era.
- [Agentic DB: The Open-Source Brain for Your Agents](https://constructive.io/blog/agentic-db-open-source.md): Introducing agentic-db — a full-stack Postgres knowledge base and personal CRM, installable in one command via pgpm. The open-source schema gives you vector search, full-text search, and auto-embeddings.
- [Agent Orchestration Doesn’t Solve Trust](https://constructive.io/blog/multi-agent-future.md): The multi-agent future just got real. Here's why it needs a trust layer at the database — and why orchestration frameworks alone can't solve the data and authorization problem.
- [Agents Are Probabilistic. Your Business Can’t Be](https://constructive.io/blog/agents-are-probabilistic.md): AI agents are inherently probabilistic, but businesses run on deterministic systems. Constructive is building secure-by-default Postgres infrastructure so the database becomes the trust boundary for the agentic era.
- [What We Mean by Secure-by-Default Postgres](https://constructive.io/blog/secure-by-default-postgres.md): Security settings and secure architecture are not the same thing. Constructive introduces the first secure-by-default Postgres platform—where RLS policies are compiled and enforced at table creation, not bolted on after the fact.
- [100 Million Downloads](https://constructive.io/blog/100-million-downloads.md): Constructive's open-source ecosystem has officially crossed 100 million npm downloads. A milestone built nearly a decade of work—and a community that made it possible.
- [Trusted LLM RAG Pipeline: Ollama & Postgres](https://constructive.io/blog/ollama-pgpm-integration.md): A reference implementation for building Retrieval-Augmented Generation (RAG) pipelines using local LLMs, Postgres, and pgvector. Real embeddings, semantic search, and end-to-end tests you can trust—all in a pgpm workspace.
- [Introducing Modular Postgres: Announcing pgpm](https://constructive.io/blog/modular-postgres-pgpm.md): Introducing pgpm and a new category: Modular Postgres. Build composable, application-layer database modules that can be installed from npm, tested in CI/CD, and deployed with idempotent migrations and automatic dependency resolution.
- [Introducing Constructive — A Trusted Open-Source Platform Built to Last](https://constructive.io/blog/introducing-constructive.md): After a decade of building open-source database tools used by Supabase, Binance, and platforms with billions in enterprise value, we're unifying everything under one name: Constructive—a secure-by-design platform for composable Postgres backends.
- [The Future of Postgres Testing: A Complete End-to-End TypeScript Approach with pgsql-test](https://constructive.io/blog/end-to-end-postgres-tests-in-typescript.md): Discover how pgsql-test brings TypeScript-native testing to Postgres with ephemeral databases, instant feedback loops, and powerful RLS testing capabilities. Making database testing feel as smooth as testing your frontend code.
- [Build Safer Supabase Apps with supabase-test](https://constructive.io/blog/supabase-test-suite.md): Unlock faster Supabase development with instant test feedback, modular workflows, and reliable RLS validation. Explore Constructive's new supabase-test library, example test harness, and tutorials for building secure, high-velocity Postgres apps.
- [KubernetesJS: The React Moment for Cloud Infrastructure](https://constructive.io/blog/kubernetesjs.md): Introducing KubernetesJS, a fully typed TypeScript client that replaces YAML and Helm with real code. Learn how this revolutionary tool brings React-like composability to Kubernetes, enables browser-based infrastructure management, and transforms DevOps with testable, modular infrastructure components. Discover why this is the React moment for cloud infrastructure.
## Optional
- [Acceptable Use Policy](https://constructive.io/legal/acceptable-use-policy.md)
- [Brand Guidelines](https://constructive.io/legal/brand-guidelines.md)
- [Disclaimer](https://constructive.io/legal/disclaimer.md)
- [License](https://constructive.io/legal/license.md)
- [Privacy Policy](https://constructive.io/legal/privacy-policy.md)
- [Terms Of Service](https://constructive.io/legal/terms-of-service.md)