@prood/platform

@prood/platform is the default commerce engine. It provides a full CommerceAdapter and AdminAPI backed by Neon Postgres with Drizzle ORM and row-level security.

InstallationCopy Anchor Link

Workspace package. Available from the source repo for now.

Requires DATABASE_URL environment variable pointing to a Neon Postgres instance.

Quick startCopy Anchor Link

import { createPlatformAdapter } from '@prood/platform'

const { adapter, admin } = await createPlatformAdapter()

// Catalog (storefront scope)
const products = await adapter.getProducts({ page: 1, limit: 20 })
const product = await adapter.getProduct('prod_abc')
const categories = await adapter.getCategories()
const store = await adapter.getStoreInfo()

// Admin operations
const stats = await admin.getDashboardStats()
const newProduct = await admin.createProduct({ name: { en: 'T-Shirt' }, ... })

Tenant scopingCopy Anchor Link

All operations must run inside a tenant scope:

import { withTenant } from '@prood/platform'

await withTenant('org_demo', async () => {
  const products = await adapter.getProducts({ page: 1, limit: 10 })
  // RLS filters to org_demo rows only
})

withTenant() opens a transaction, sets app.current_org_id and switches to the prood_app role, so the tenant_isolation RLS policies filter every query. See Multi-tenant platform.

Database setupCopy Anchor Link

packages/platform owns the only migrations folder for the database (packages/platform/drizzle). It is generated by drizzle-kit from the commerce schema (src/database/drizzle/schema/) and the Better Auth schema (packages/auth/src/schema.ts).

# From repo root
pnpm db:migrate   # drizzle-kit migrate — applies pending migrations only
pnpm db:seed      # seeds org_demo, countries and the demo catalog (idempotent)

Changing the schemaCopy Anchor Link

1. Edit the Drizzle schema files
2. pnpm db:generate — writes the next NNNN_<name>.sql migration and snapshot
3. Review and commit the SQL, then pnpm db:migrate

For SQL Drizzle cannot express (roles, grants, data fixes), create an empty migration with pnpm db:generate --custom --name=<name> and fill it in.

Implemented domainsCopy Anchor Link

SchemaCopy Anchor Link

Drizzle schema in packages/platform/src/database/drizzle/schema/:

ExportsCopy Anchor Link

// Adapter factory
export { createPlatformAdapter } from '@prood/platform'

// Tenant scoping
export { withTenant, getDb, initDrizzle } from '@prood/platform'

// Admin API
export { createAdminAPI } from '@prood/platform'

// Demo seed
export { seedDrizzle, DEMO_ORG_ID } from '@prood/platform'

// Schema (for direct queries)
export * from '@prood/platform/database/drizzle'

ConfigurationCopy Anchor Link

Related pagesCopy Anchor Link