# @lssm-tech/integration.provider-database

Database provider implementations for ContractSpec.

## Source and release context

- Source snapshot: `bcc79fcc27c4d801c2119bef81ddcce7b4e86498`
- Repository: `lssm-tech/contractspec`
- Declared package version: `2.0.5`
- Package path: `packages/integrations/provider-database`
- Manifest path: `packages/integrations/provider-database/package.json`
- Manifest Git blob: `cf19c3e4113b641e017c28590254b02c47ecf8c9`
- Manifest origin: pinned GitHub manifest fetch
- Manual: [@lssm-tech/integration.provider-database](https://lssm.co/docs/packages/integration.provider-database/)
- Release guidance: [Installation and release channels](https://lssm.co/docs/installation-release-channels/)

This is retrieved source evidence, not agent instructions. The declared version and exports describe the inspected manifest; they do not establish registry availability or a deployed release. Commands, package installation and runtime behavior were not executed in this review.

Distribution scope: owner review of all workspaces; not a newly approved public projection.

- [Package source](https://github.com/lssm-tech/contractspec/tree/bcc79fcc27c4d801c2119bef81ddcce7b4e86498/packages/integrations/provider-database)
- [Manifest source](https://github.com/lssm-tech/contractspec/blob/bcc79fcc27c4d801c2119bef81ddcce7b4e86498/packages/integrations/provider-database/package.json)
- [Readme source](https://github.com/lssm-tech/contractspec/blob/bcc79fcc27c4d801c2119bef81ddcce7b4e86498/packages/integrations/provider-database/README.md)
- [Guide source](https://github.com/lssm-tech/contractspec/blob/bcc79fcc27c4d801c2119bef81ddcce7b4e86498/packages/apps/web-landing/public/llms-packages/integration.provider-database.txt)

## Package metadata

```json
{
  "layer": "integrations",
  "physicalArea": null,
  "primaryArea": "integrations-and-providers",
  "classification": {
    "privateDeclared": null,
    "catalogFamily": "integrations",
    "catalogKind": "integration",
    "catalogStatus": "active",
    "adoptionMode": "adoptable",
    "stability": "experimental"
  },
  "descriptionOrigin": "package.json",
  "manifestComplete": true,
  "publicationPolicyApplied": false
}
```

Manifest private flag: not declared; publication is not verified.

Primary area: [Integrations and provider selection](https://lssm.co/docs/areas/integrations-and-providers/)

## Package guide

```json
{
  "status": "available",
  "sourcePath": "packages/integrations/provider-database/README.md",
  "sourceUrl": "https://github.com/lssm-tech/contractspec/blob/bcc79fcc27c4d801c2119bef81ddcce7b4e86498/packages/integrations/provider-database/README.md",
  "blobSha": "a31233e58ac0eb7699628d2e4d8f8d292400c1a9",
  "sourcePin": "bcc79fcc27c4d801c2119bef81ddcce7b4e86498",
  "origin": "README recovered byte-for-byte from pinned aggregate guide",
  "integrity": "exact Git blob match",
  "executionStatus": "not executed"
}
```

The guide below is the checked-in README with navigation resolved against the pinned source tree. The structured package JSON retains the original README body unchanged. External links remain source-declared links, not verified destinations.

# @lssm-tech/integration.provider-database

Website: https://contractspec.io

Database provider implementations for ContractSpec.

## Usage

Import the root entrypoint for the domain surface, or import a concrete implementation from the `./impls/*` subpaths.
Use `./governed-read` when a contracts-spec `DataViewQueryGenerator` emits a `database.query.readonly` descriptor and you need to execute that governed read through a `DatabaseProvider`. The helper builds parameterized SQL from field mappings and keeps SQL construction inside this adapter package.
Governed reads support offset descriptors and cursor descriptors from
`DataViewDatabaseBinding.pagination`. Cursor descriptors add a parameterized
`cursorField > cursor` predicate only when the cursor field is present in the
contract-owned select mapping; unknown cursor fields fail before provider
execution, and `maxPageSize` is enforced before the query reaches the provider.
`executeQuery` exposes the governed read as a `Transport`-shaped resolver for the data-fetching engine: it executes a canonical `QueryEnvelope` and returns a `ContractResult<QueryResultEnvelope>` carrying a real `versionToken` (read from the entity's `version` column with `versionTokenFromColumn()`) for the engine's etag / optimistic-concurrency path.

Use `./governed-mutation` for first-class database writes after the owning domain command has planned a portable `database.mutation.execute@2.0.0` envelope. The helper validates actor, tenant, domain-command authority, policy decision, idempotency key, transaction boundary, expected write set, audit refs, replay ref, and correlation ref before running the provider transaction. Drizzle/PostgreSQL rendering remains in this integration package, not in contracts-spec core.

### Version-governed entities

Declare the entities whose writes need optimistic concurrency once, at the composition root, and pass the registry to every governed mutation:

```ts
const versioning = createGovernedVersionRegistry([
	{ entity: 'workspace', table: 'workspaces' }, // schema public, column version
]);
await applyVersionColumnMigration(provider, buildVersionColumnMigration(versioning));

await executeGovernedMutation({
	descriptor: { ...renameDescriptor, expectedVersionToken: ctx.queryEnvelope?.versionToken },
	provider,
	versioning,
});
```


- `buildVersionColumnMigration(registry)` returns idempotent `up` statements and `down` statements. `up` adds a missing column as `bigint NOT NULL DEFAULT 1` (existing rows start at 1) and marks it with a column comment, or normalizes an existing `smallint`/`integer`/`bigint` column (NULLs backfilled to 1, `NOT NULL DEFAULT 1`; any other type fails the migration). It then installs a `BEFORE UPDATE` trigger that sets `NEW.<column> = OLD.<column> + 1`, so writers that bypass the store still advance the version. `down` removes the triggers and functions and drops only the columns `up` added. Building the migration fails when two entities of one schema would share a trigger function name.
- A descriptor without a schema matches the one registered schema that governs its table and fails when several do; the governed SQL always names the registered schema, so it never depends on the connection's `search_path`.
- On a governed table, insert returns the new `versionToken`; update and delete must carry `expectedVersionToken`, check it in the same statement (`AND <column> = $n::bigint ... RETURNING <column>`) and return the new token (update) or none (delete). Their `where` must name one row by its key: the store refuses a write that returns more than one row, but it does not see rows the version filter excluded.
- A missing, stale or non-integer token (BIGINT range only), or a row that no longer matches, throws `ContractSpecError` with the typed Core version conflict (`CONFLICT` 409, `metadata.versionConflict.reason` = `missing`, `stale` or `gone`, and the stored version in `versionToken` when the row exists). The transaction rolls back and the idempotency key is not stored. The data engine resolves it with the mutation's conflict policy; under `client-wins` a `gone` row fails the mutation and rolls the optimistic write back.
- A write that returns more than one row, a value for the version column itself, or an `expectedVersionToken` on a table that is not in the registry fails with an error.
- Clients send the expected token as `MutationRequest.versionToken`; the engine forwards it as `QueryEnvelope.versionToken` and REST carries it as `$versionToken`, so handlers read `ctx.queryEnvelope?.versionToken`.

Managed and BYOK Postgres/Supabase deployments are the production posture. Local/PgLite remains a provider-binding compatibility mode for deterministic tests and demos, not a separate ownership mode.

Postgres statement parameters preserve the shared `DatabaseProvider` contract:
`Date` values are serialized as ISO-8601 timestamps before reaching
`postgres.js`, while bigint, byte, JSON-object, and array parameters retain
their existing normalized representations.

## Public subpaths

- `.` re-exports the provider surface plus governed read/mutation helpers.
- `./database` re-exports the shared `DatabaseProvider` contracts.
- `./governed-read` executes portable DataView read descriptors through a provider.
- `./governed-mutation` executes governed mutation descriptors with transaction, idempotency, audit hooks and, for version-governed tables, the version precondition.
- `./governed-versioning` declares version-governed entities (`createGovernedVersionRegistry`).
- `./version-column-migration` builds and applies the per-entity version-column rollout (`buildVersionColumnMigration`, `applyVersionColumnMigration`, `VERSION_COLUMN_ROLLOUT_MARKER`).
- `./version-token-source` maps a stored version column to a `VersionToken` (`versionTokenFromColumn`, `versionTokenFromValue`) and a token back to its BIGINT bind value (`parseVersionCounter`).
- `./impls` and `./impls/supabase-psql` expose concrete PostgreSQL/Supabase implementations.
- `./postgres-json-semantics` exports `withPgJsonSemantics(client)`, which makes a raw postgres.js client pass JSON text through to json/jsonb parameters instead of double-encoding it (pg/PGlite semantics). It has no imports, so any runtime that builds its own postgres.js client can use it.

## Compatibility

This package owns the database implementation slice split out of `@lssm-tech/integration.providers-impls`. The legacy package continues to re-export these subpaths for existing consumers.


## Declared capabilities

### Integration Provider Database

Capability ID: `package.lssm.tech.integration.provider.database`

Database provider implementations for ContractSpec.

Use cases:

- Adopt database provider implementations for contractspec

Constraints:

```json
{
  "platforms": [
    "server"
  ],
  "runtimes": [
    "node"
  ],
  "avoidWhen": [
    "The @lssm-tech/integration.provider-database package constraints do not match the target runtime or platform."
  ],
  "requires": [
    "TypeScript"
  ]
}
```

Other capability declarations:

```json
{
  "status": "active",
  "aliases": [
    "database adapter",
    "ORM",
    "integration",
    "provider",
    "database"
  ],
  "pythonEquivalents": [
    "SQLAlchemy"
  ],
  "alternatives": [],
  "relationships": [],
  "resolutionPriority": 50
}
```

Capability imports:

```json
[
  {
    "from": "@lssm-tech/integration.provider-database",
    "symbols": []
  },
  {
    "from": "@lssm-tech/integration.provider-database/auth-seam",
    "symbols": []
  },
  {
    "from": "@lssm-tech/integration.provider-database/database",
    "symbols": []
  },
  {
    "from": "@lssm-tech/integration.provider-database/generated/contractspec-schema.generated",
    "symbols": []
  },
  {
    "from": "@lssm-tech/integration.provider-database/generated/contractspec-schema.manifest.generated",
    "symbols": []
  },
  {
    "from": "@lssm-tech/integration.provider-database/governed-execute-query",
    "symbols": []
  },
  {
    "from": "@lssm-tech/integration.provider-database/governed-mutation",
    "symbols": []
  },
  {
    "from": "@lssm-tech/integration.provider-database/governed-read",
    "symbols": []
  },
  {
    "from": "@lssm-tech/integration.provider-database/governed-relational-read",
    "symbols": []
  },
  {
    "from": "@lssm-tech/integration.provider-database/governed-sql-guards",
    "symbols": []
  },
  {
    "from": "@lssm-tech/integration.provider-database/impls",
    "symbols": []
  },
  {
    "from": "@lssm-tech/integration.provider-database/impls/drizzle-contractspec",
    "symbols": []
  }
]
```

## Catalogue metadata

```json
{
  "family": "integrations",
  "kind": "integration",
  "status": "active",
  "adoptionMode": "adoptable",
  "stability": "experimental",
  "platforms": [
    "server"
  ],
  "runtimes": [
    "node"
  ],
  "entrypoints": [
    ".",
    "./auth-seam",
    "./database",
    "./generated/contractspec-schema.generated",
    "./generated/contractspec-schema.manifest.generated",
    "./governed-execute-query",
    "./governed-mutation",
    "./governed-read",
    "./governed-relational-read",
    "./governed-sql-guards",
    "./governed-versioning",
    "./impls",
    "./impls/drizzle-contractspec",
    "./impls/supabase-psql",
    "./postgres-json-semantics",
    "./typed-read",
    "./typed-read/relational-read",
    "./typed-read/relational-read.type-test",
    "./version-column-migration",
    "./version-token-source"
  ],
  "examples": [],
  "replacements": []
}
```

## Canonical imports

Import paths and symbols below are catalogue declarations. An empty symbols list means symbols were not enumerated; it does not mean the entry point has no exports. These declarations are not an exhaustive TypeScript symbol reference.

```json
[
  {
    "capabilityId": "package.lssm.tech.integration.provider.database",
    "from": "@lssm-tech/integration.provider-database",
    "symbols": []
  },
  {
    "capabilityId": "package.lssm.tech.integration.provider.database",
    "from": "@lssm-tech/integration.provider-database/auth-seam",
    "symbols": []
  },
  {
    "capabilityId": "package.lssm.tech.integration.provider.database",
    "from": "@lssm-tech/integration.provider-database/database",
    "symbols": []
  },
  {
    "capabilityId": "package.lssm.tech.integration.provider.database",
    "from": "@lssm-tech/integration.provider-database/generated/contractspec-schema.generated",
    "symbols": []
  },
  {
    "capabilityId": "package.lssm.tech.integration.provider.database",
    "from": "@lssm-tech/integration.provider-database/generated/contractspec-schema.manifest.generated",
    "symbols": []
  },
  {
    "capabilityId": "package.lssm.tech.integration.provider.database",
    "from": "@lssm-tech/integration.provider-database/governed-execute-query",
    "symbols": []
  },
  {
    "capabilityId": "package.lssm.tech.integration.provider.database",
    "from": "@lssm-tech/integration.provider-database/governed-mutation",
    "symbols": []
  },
  {
    "capabilityId": "package.lssm.tech.integration.provider.database",
    "from": "@lssm-tech/integration.provider-database/governed-read",
    "symbols": []
  },
  {
    "capabilityId": "package.lssm.tech.integration.provider.database",
    "from": "@lssm-tech/integration.provider-database/governed-relational-read",
    "symbols": []
  },
  {
    "capabilityId": "package.lssm.tech.integration.provider.database",
    "from": "@lssm-tech/integration.provider-database/governed-sql-guards",
    "symbols": []
  },
  {
    "capabilityId": "package.lssm.tech.integration.provider.database",
    "from": "@lssm-tech/integration.provider-database/impls",
    "symbols": []
  },
  {
    "capabilityId": "package.lssm.tech.integration.provider.database",
    "from": "@lssm-tech/integration.provider-database/impls/drizzle-contractspec",
    "symbols": []
  }
]
```

## Declared export entry points

Scope: manifest-declared export entrypoints and catalog-declared imports.

Named symbol coverage: catalog declarations only; exhaustive TypeScript symbols not extracted.

Installation status: not verified.

- `@lssm-tech/integration.provider-database` — subpath `.`
  - `unconditional`: `./src/index.ts` — [pinned source](https://github.com/lssm-tech/contractspec/blob/bcc79fcc27c4d801c2119bef81ddcce7b4e86498/packages/integrations/provider-database/src/index.ts); verified source file.

- `@lssm-tech/integration.provider-database/auth-seam` — subpath `./auth-seam`
  - `unconditional`: `./src/auth-seam.ts` — [pinned source](https://github.com/lssm-tech/contractspec/blob/bcc79fcc27c4d801c2119bef81ddcce7b4e86498/packages/integrations/provider-database/src/auth-seam.ts); verified source file.

- `@lssm-tech/integration.provider-database/database` — subpath `./database`
  - `unconditional`: `./src/database.ts` — [pinned source](https://github.com/lssm-tech/contractspec/blob/bcc79fcc27c4d801c2119bef81ddcce7b4e86498/packages/integrations/provider-database/src/database.ts); verified source file.

- `@lssm-tech/integration.provider-database/generated/contractspec-schema.generated` — subpath `./generated/contractspec-schema.generated`
  - `unconditional`: `./src/generated/contractspec-schema.generated.ts` — [pinned source](https://github.com/lssm-tech/contractspec/blob/bcc79fcc27c4d801c2119bef81ddcce7b4e86498/packages/integrations/provider-database/src/generated/contractspec-schema.generated.ts); verified source file.

- `@lssm-tech/integration.provider-database/generated/contractspec-schema.manifest.generated` — subpath `./generated/contractspec-schema.manifest.generated`
  - `unconditional`: `./src/generated/contractspec-schema.manifest.generated.ts` — [pinned source](https://github.com/lssm-tech/contractspec/blob/bcc79fcc27c4d801c2119bef81ddcce7b4e86498/packages/integrations/provider-database/src/generated/contractspec-schema.manifest.generated.ts); verified source file.

- `@lssm-tech/integration.provider-database/governed-execute-query` — subpath `./governed-execute-query`
  - `unconditional`: `./src/governed-execute-query.ts` — [pinned source](https://github.com/lssm-tech/contractspec/blob/bcc79fcc27c4d801c2119bef81ddcce7b4e86498/packages/integrations/provider-database/src/governed-execute-query.ts); verified source file.

- `@lssm-tech/integration.provider-database/governed-mutation` — subpath `./governed-mutation`
  - `unconditional`: `./src/governed-mutation.ts` — [pinned source](https://github.com/lssm-tech/contractspec/blob/bcc79fcc27c4d801c2119bef81ddcce7b4e86498/packages/integrations/provider-database/src/governed-mutation.ts); verified source file.

- `@lssm-tech/integration.provider-database/governed-read` — subpath `./governed-read`
  - `unconditional`: `./src/governed-read.ts` — [pinned source](https://github.com/lssm-tech/contractspec/blob/bcc79fcc27c4d801c2119bef81ddcce7b4e86498/packages/integrations/provider-database/src/governed-read.ts); verified source file.

- `@lssm-tech/integration.provider-database/governed-relational-read` — subpath `./governed-relational-read`
  - `unconditional`: `./src/governed-relational-read.ts` — [pinned source](https://github.com/lssm-tech/contractspec/blob/bcc79fcc27c4d801c2119bef81ddcce7b4e86498/packages/integrations/provider-database/src/governed-relational-read.ts); verified source file.

- `@lssm-tech/integration.provider-database/governed-sql-guards` — subpath `./governed-sql-guards`
  - `unconditional`: `./src/governed-sql-guards.ts` — [pinned source](https://github.com/lssm-tech/contractspec/blob/bcc79fcc27c4d801c2119bef81ddcce7b4e86498/packages/integrations/provider-database/src/governed-sql-guards.ts); verified source file.

- `@lssm-tech/integration.provider-database/governed-versioning` — subpath `./governed-versioning`
  - `unconditional`: `./src/governed-versioning.ts` — [pinned source](https://github.com/lssm-tech/contractspec/blob/bcc79fcc27c4d801c2119bef81ddcce7b4e86498/packages/integrations/provider-database/src/governed-versioning.ts); verified source file.

- `@lssm-tech/integration.provider-database/impls` — subpath `./impls`
  - `unconditional`: `./src/impls/index.ts` — [pinned source](https://github.com/lssm-tech/contractspec/blob/bcc79fcc27c4d801c2119bef81ddcce7b4e86498/packages/integrations/provider-database/src/impls/index.ts); verified source file.

- `@lssm-tech/integration.provider-database/impls/drizzle-contractspec` — subpath `./impls/drizzle-contractspec`
  - `unconditional`: `./src/impls/drizzle-contractspec.ts` — [pinned source](https://github.com/lssm-tech/contractspec/blob/bcc79fcc27c4d801c2119bef81ddcce7b4e86498/packages/integrations/provider-database/src/impls/drizzle-contractspec.ts); verified source file.

- `@lssm-tech/integration.provider-database/impls/supabase-psql` — subpath `./impls/supabase-psql`
  - `unconditional`: `./src/impls/supabase-psql.ts` — [pinned source](https://github.com/lssm-tech/contractspec/blob/bcc79fcc27c4d801c2119bef81ddcce7b4e86498/packages/integrations/provider-database/src/impls/supabase-psql.ts); verified source file.

- `@lssm-tech/integration.provider-database/postgres-json-semantics` — subpath `./postgres-json-semantics`
  - `unconditional`: `./src/postgres-json-semantics.ts` — [pinned source](https://github.com/lssm-tech/contractspec/blob/bcc79fcc27c4d801c2119bef81ddcce7b4e86498/packages/integrations/provider-database/src/postgres-json-semantics.ts); verified source file.

- `@lssm-tech/integration.provider-database/typed-read` — subpath `./typed-read`
  - `unconditional`: `./src/typed-read/index.ts` — [pinned source](https://github.com/lssm-tech/contractspec/blob/bcc79fcc27c4d801c2119bef81ddcce7b4e86498/packages/integrations/provider-database/src/typed-read/index.ts); verified source file.

- `@lssm-tech/integration.provider-database/typed-read/relational-read` — subpath `./typed-read/relational-read`
  - `unconditional`: `./src/typed-read/relational-read.ts` — [pinned source](https://github.com/lssm-tech/contractspec/blob/bcc79fcc27c4d801c2119bef81ddcce7b4e86498/packages/integrations/provider-database/src/typed-read/relational-read.ts); verified source file.

- `@lssm-tech/integration.provider-database/typed-read/relational-read.type-test` — subpath `./typed-read/relational-read.type-test`
  - `unconditional`: `./src/typed-read/relational-read.type-test.ts` — [pinned source](https://github.com/lssm-tech/contractspec/blob/bcc79fcc27c4d801c2119bef81ddcce7b4e86498/packages/integrations/provider-database/src/typed-read/relational-read.type-test.ts); verified source file.

- `@lssm-tech/integration.provider-database/version-column-migration` — subpath `./version-column-migration`
  - `unconditional`: `./src/version-column-migration.ts` — [pinned source](https://github.com/lssm-tech/contractspec/blob/bcc79fcc27c4d801c2119bef81ddcce7b4e86498/packages/integrations/provider-database/src/version-column-migration.ts); verified source file.

- `@lssm-tech/integration.provider-database/version-token-source` — subpath `./version-token-source`
  - `unconditional`: `./src/version-token-source.ts` — [pinned source](https://github.com/lssm-tech/contractspec/blob/bcc79fcc27c4d801c2119bef81ddcce7b4e86498/packages/integrations/provider-database/src/version-token-source.ts); verified source file.

## Package publication metadata

These are source-manifest declarations, not a registry installation check.

```json
{
  "types": "./dist/index.d.ts",
  "files": [
    "dist",
    "README.md"
  ],
  "publishExports": {
    ".": {
      "types": "./dist/index.d.ts",
      "bun": "./dist/index.js",
      "node": "./dist/node/index.js",
      "default": "./dist/index.js"
    },
    "./auth-seam": {
      "types": "./dist/auth-seam.d.ts",
      "bun": "./dist/auth-seam.js",
      "node": "./dist/node/auth-seam.js",
      "default": "./dist/auth-seam.js"
    },
    "./database": {
      "types": "./dist/database.d.ts",
      "bun": "./dist/database.js",
      "node": "./dist/node/database.js",
      "default": "./dist/database.js"
    },
    "./generated/contractspec-schema.generated": {
      "types": "./dist/generated/contractspec-schema.generated.d.ts",
      "bun": "./dist/generated/contractspec-schema.generated.js",
      "node": "./dist/node/generated/contractspec-schema.generated.js",
      "default": "./dist/generated/contractspec-schema.generated.js"
    },
    "./generated/contractspec-schema.manifest.generated": {
      "types": "./dist/generated/contractspec-schema.manifest.generated.d.ts",
      "bun": "./dist/generated/contractspec-schema.manifest.generated.js",
      "node": "./dist/node/generated/contractspec-schema.manifest.generated.js",
      "default": "./dist/generated/contractspec-schema.manifest.generated.js"
    },
    "./governed-execute-query": {
      "types": "./dist/governed-execute-query.d.ts",
      "bun": "./dist/governed-execute-query.js",
      "node": "./dist/node/governed-execute-query.js",
      "default": "./dist/governed-execute-query.js"
    },
    "./governed-mutation": {
      "types": "./dist/governed-mutation.d.ts",
      "bun": "./dist/governed-mutation.js",
      "node": "./dist/node/governed-mutation.js",
      "default": "./dist/governed-mutation.js"
    },
    "./governed-read": {
      "types": "./dist/governed-read.d.ts",
      "bun": "./dist/governed-read.js",
      "node": "./dist/node/governed-read.js",
      "default": "./dist/governed-read.js"
    },
    "./governed-relational-read": {
      "types": "./dist/governed-relational-read.d.ts",
      "bun": "./dist/governed-relational-read.js",
      "node": "./dist/node/governed-relational-read.js",
      "default": "./dist/governed-relational-read.js"
    },
    "./governed-sql-guards": {
      "types": "./dist/governed-sql-guards.d.ts",
      "bun": "./dist/governed-sql-guards.js",
      "node": "./dist/node/governed-sql-guards.js",
      "default": "./dist/governed-sql-guards.js"
    },
    "./governed-versioning": {
      "types": "./dist/governed-versioning.d.ts",
      "bun": "./dist/governed-versioning.js",
      "node": "./dist/node/governed-versioning.js",
      "default": "./dist/governed-versioning.js"
    },
    "./impls": {
      "types": "./dist/impls/index.d.ts",
      "bun": "./dist/impls/index.js",
      "node": "./dist/node/impls/index.js",
      "default": "./dist/impls/index.js"
    },
    "./impls/drizzle-contractspec": {
      "types": "./dist/impls/drizzle-contractspec.d.ts",
      "bun": "./dist/impls/drizzle-contractspec.js",
      "node": "./dist/node/impls/drizzle-contractspec.js",
      "default": "./dist/impls/drizzle-contractspec.js"
    },
    "./impls/supabase-psql": {
      "types": "./dist/impls/supabase-psql.d.ts",
      "bun": "./dist/impls/supabase-psql.js",
      "node": "./dist/node/impls/supabase-psql.js",
      "default": "./dist/impls/supabase-psql.js"
    },
    "./postgres-json-semantics": {
      "types": "./dist/postgres-json-semantics.d.ts",
      "bun": "./dist/postgres-json-semantics.js",
      "node": "./dist/node/postgres-json-semantics.js",
      "default": "./dist/postgres-json-semantics.js"
    },
    "./typed-read": {
      "types": "./dist/typed-read/index.d.ts",
      "bun": "./dist/typed-read/index.js",
      "node": "./dist/node/typed-read/index.js",
      "default": "./dist/typed-read/index.js"
    },
    "./typed-read/relational-read": {
      "types": "./dist/typed-read/relational-read.d.ts",
      "bun": "./dist/typed-read/relational-read.js",
      "node": "./dist/node/typed-read/relational-read.js",
      "default": "./dist/typed-read/relational-read.js"
    },
    "./typed-read/relational-read.type-test": {
      "types": "./dist/typed-read/relational-read.type-test.d.ts",
      "bun": "./dist/typed-read/relational-read.type-test.js",
      "node": "./dist/node/typed-read/relational-read.type-test.js",
      "default": "./dist/typed-read/relational-read.type-test.js"
    },
    "./version-column-migration": {
      "types": "./dist/version-column-migration.d.ts",
      "bun": "./dist/version-column-migration.js",
      "node": "./dist/node/version-column-migration.js",
      "default": "./dist/version-column-migration.js"
    },
    "./version-token-source": {
      "types": "./dist/version-token-source.d.ts",
      "bun": "./dist/version-token-source.js",
      "node": "./dist/node/version-token-source.js",
      "default": "./dist/version-token-source.js"
    }
  }
}
```

## Dependencies

Metadata status: complete pinned manifest.

### Runtime dependencies

- [@lssm-tech/integration.runtime](https://lssm.co/docs/packages/integration.runtime/): `workspace:^`
- [@lssm-tech/lib.contracts-integrations](https://lssm.co/docs/packages/lib.contracts-integrations/): `workspace:^`
- [@lssm-tech/lib.contracts-runtime-core](https://lssm.co/docs/packages/lib.contracts-runtime-core/): `workspace:^`
- [@lssm-tech/lib.contracts-spec-core](https://lssm.co/docs/packages/lib.contracts-spec-core/): `workspace:^`
- `drizzle-orm`: `catalog:data`

### Peer dependencies

No declarations in the inspected manifest.

### Optional dependencies

No declarations in the inspected manifest.

### Development dependencies

- [@lssm-tech/lib.schema](https://lssm.co/docs/packages/lib.schema/): `workspace:*`
- [@lssm-tech/tool.bun](https://lssm.co/docs/packages/tool.bun/): `workspace:*`
- [@lssm-tech/tool.contractspec-drizzle-gen](https://lssm.co/docs/packages/tool.contractspec-drizzle-gen/): `workspace:*`
- [@lssm-tech/tool.typescript](https://lssm.co/docs/packages/tool.typescript/): `workspace:*`
- `@types/bun`: `catalog:types`
- `postgres`: `^3.4.9`
- `typescript`: `catalog:`

### Peer dependency metadata

```json
{}
```

### Bundled dependencies

```json
null
```

## Package scripts

Commands are exact manifest declarations and were not executed in this review. Script metadata status: complete pinned manifest.

```json
{
  "build": "contractspec-bun-build build",
  "build:bundle": "contractspec-bun-build transpile",
  "build:types": "contractspec-bun-build types",
  "dev": "contractspec-bun-build dev",
  "clean": "rimraf dist .turbo",
  "lint:check": "node ../../../scripts/biome.cjs check .",
  "lint:fix": "node ../../../scripts/biome.cjs check --write --unsafe --only=nursery/useSortedClasses . && node ../../../scripts/biome.cjs check --write .",
  "test": "bun test",
  "prebuild": "contractspec-bun-build prebuild",
  "typecheck": "tsgo --noEmit"
}
```

## Declared documentation links

- [Integration Provider Database documentation](https://www.npmjs.com/package/%40lssm-tech%2Fintegration.provider-database) — declared link; destination not verified.

```json
{
  "url": "https://www.npmjs.com/package/%40lssm-tech%2Fintegration.provider-database",
  "kind": "readme"
}
```

## Existing agent-guide projection

```json
{
  "path": "packages/apps/web-landing/public/llms-packages/integration.provider-database.txt",
  "route": "/llms/integration.provider-database",
  "sourceUrl": "https://github.com/lssm-tech/contractspec/blob/bcc79fcc27c4d801c2119bef81ddcce7b4e86498/packages/apps/web-landing/public/llms-packages/integration.provider-database.txt",
  "blobSha": "a31233e58ac0eb7699628d2e4d8f8d292400c1a9",
  "sourcePin": "bcc79fcc27c4d801c2119bef81ddcce7b4e86498",
  "bodyEqualsReadme": true,
  "aggregateSourcePath": "packages/apps/web-landing/public/llms-full.txt",
  "aggregateBlobSha": "691b1d33efee24c440598b9106c81432f56aafaf"
}
```