# @lssm-tech/integration.integration-topology-evidence-postgres

Tenant-scoped append-only Postgres evidence adapter for Integration Hub topology receipts.

## Source and release context

- Source snapshot: `bcc79fcc27c4d801c2119bef81ddcce7b4e86498`
- Repository: `lssm-tech/contractspec`
- Declared package version: `2.0.5`
- Package path: `packages/integrations/integration-topology-evidence-postgres`
- Manifest path: `packages/integrations/integration-topology-evidence-postgres/package.json`
- Manifest Git blob: `fff406ea2e987a75ad469ae4b79b5761d5ab877a`
- Manifest origin: pinned GitHub manifest fetch
- Manual: [@lssm-tech/integration.integration-topology-evidence-postgres](https://lssm.co/docs/packages/integration.integration-topology-evidence-postgres/)
- 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/integration-topology-evidence-postgres)
- [Manifest source](https://github.com/lssm-tech/contractspec/blob/bcc79fcc27c4d801c2119bef81ddcce7b4e86498/packages/integrations/integration-topology-evidence-postgres/package.json)
- [Readme source](https://github.com/lssm-tech/contractspec/blob/bcc79fcc27c4d801c2119bef81ddcce7b4e86498/packages/integrations/integration-topology-evidence-postgres/README.md)
- [Guide source](https://github.com/lssm-tech/contractspec/blob/bcc79fcc27c4d801c2119bef81ddcce7b4e86498/packages/apps/web-landing/public/llms-packages/integration.integration-topology-evidence-postgres.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/integration-topology-evidence-postgres/README.md",
  "sourceUrl": "https://github.com/lssm-tech/contractspec/blob/bcc79fcc27c4d801c2119bef81ddcce7b4e86498/packages/integrations/integration-topology-evidence-postgres/README.md",
  "blobSha": "05b92872686294a38a1333d357940a53a3c6e65e",
  "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.

# Integration topology evidence — Postgres

Postgres adapter for Integration Hub's `IntegrationTopologyEvidencePort`.
It stores only already-verified, secret-free provider receipt projections and
reads them through an exact tenant, workspace, environment, integration,
connection, and topology-digest binding.

The host owns the table migration, tenant-scoped `DatabaseProvider`, and the
provider-specific receipt verifier. This package never calls a provider and
never turns offline conformance or deployment metadata into live evidence.

`appendVerified` is idempotent for an exact receipt and rejects receipt-reference
reuse with a different payload. Stored payloads are closed-world decoded,
digest-checked, and structurally reassessed on every read.


## Declared capabilities

### Integration topology evidence Postgres

Capability ID: `package.lssm.tech.integration.integration.topology.evidence.postgres`

Persist verified Integration Hub topology receipt projections with exact tenant binding.

Use cases:

- Persist verified topology evidence without provider coupling

Constraints:

```json
{
  "platforms": [
    "server"
  ],
  "runtimes": [
    "bun",
    "node"
  ],
  "avoidWhen": [
    "A tenant-scoped DatabaseProvider is unavailable."
  ],
  "requires": [
    "PostgreSQL",
    "TypeScript"
  ]
}
```

Other capability declarations:

```json
{
  "status": "active",
  "aliases": [
    "integration",
    "topology",
    "evidence",
    "postgres"
  ],
  "pythonEquivalents": [],
  "alternatives": [],
  "relationships": [],
  "resolutionPriority": 50
}
```

Capability imports:

```json
[
  {
    "from": "@lssm-tech/integration.integration-topology-evidence-postgres",
    "symbols": [
      "PostgresIntegrationTopologyEvidenceStore"
    ]
  }
]
```

## Catalogue metadata

```json
{
  "family": "integrations",
  "kind": "integration",
  "status": "active",
  "adoptionMode": "adoptable",
  "stability": "experimental",
  "platforms": [
    "server"
  ],
  "runtimes": [
    "bun",
    "node"
  ],
  "entrypoints": [
    "."
  ]
}
```

## 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.integration.topology.evidence.postgres",
    "from": "@lssm-tech/integration.integration-topology-evidence-postgres",
    "symbols": [
      "PostgresIntegrationTopologyEvidenceStore"
    ]
  }
]
```

## 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.integration-topology-evidence-postgres` — subpath `.`
  - `unconditional`: `./src/index.ts` — [pinned source](https://github.com/lssm-tech/contractspec/blob/bcc79fcc27c4d801c2119bef81ddcce7b4e86498/packages/integrations/integration-topology-evidence-postgres/src/index.ts); verified source file.

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

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

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

- `@lssm-tech/integration.integration-topology-evidence-postgres/receipt-scope-codec` — subpath `./receipt-scope-codec`
  - `unconditional`: `./src/receipt-scope-codec.ts` — [pinned source](https://github.com/lssm-tech/contractspec/blob/bcc79fcc27c4d801c2119bef81ddcce7b4e86498/packages/integrations/integration-topology-evidence-postgres/src/receipt-scope-codec.ts); verified source file.

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

- `@lssm-tech/integration.integration-topology-evidence-postgres/store-queries` — subpath `./store-queries`
  - `unconditional`: `./src/store-queries.ts` — [pinned source](https://github.com/lssm-tech/contractspec/blob/bcc79fcc27c4d801c2119bef81ddcce7b4e86498/packages/integrations/integration-topology-evidence-postgres/src/store-queries.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",
    "AGENTS.md"
  ],
  "publishExports": {
    ".": {
      "types": "./dist/index.d.ts",
      "bun": "./dist/index.js",
      "node": "./dist/node/index.js",
      "default": "./dist/index.js"
    },
    "./canonical-json": {
      "types": "./dist/canonical-json.d.ts",
      "bun": "./dist/canonical-json.js",
      "node": "./dist/node/canonical-json.js",
      "default": "./dist/canonical-json.js"
    },
    "./codec-primitives": {
      "types": "./dist/codec-primitives.d.ts",
      "bun": "./dist/codec-primitives.js",
      "node": "./dist/node/codec-primitives.js",
      "default": "./dist/codec-primitives.js"
    },
    "./receipt-codec": {
      "types": "./dist/receipt-codec.d.ts",
      "bun": "./dist/receipt-codec.js",
      "node": "./dist/node/receipt-codec.js",
      "default": "./dist/receipt-codec.js"
    },
    "./receipt-scope-codec": {
      "types": "./dist/receipt-scope-codec.d.ts",
      "bun": "./dist/receipt-scope-codec.js",
      "node": "./dist/node/receipt-scope-codec.js",
      "default": "./dist/receipt-scope-codec.js"
    },
    "./store": {
      "types": "./dist/store.d.ts",
      "bun": "./dist/store.js",
      "node": "./dist/node/store.js",
      "default": "./dist/store.js"
    },
    "./store-queries": {
      "types": "./dist/store-queries.d.ts",
      "bun": "./dist/store-queries.js",
      "node": "./dist/node/store-queries.js",
      "default": "./dist/store-queries.js"
    }
  }
}
```

## Dependencies

Metadata status: complete pinned manifest.

### Runtime dependencies

- [@lssm-tech/lib.contracts-integrations](https://lssm.co/docs/packages/lib.contracts-integrations/): `workspace:^`

### Peer dependencies

No declarations in the inspected manifest.

### Optional dependencies

No declarations in the inspected manifest.

### Development dependencies

- [@lssm-tech/tool.bun](https://lssm.co/docs/packages/tool.bun/): `workspace:*`
- [@lssm-tech/tool.typescript](https://lssm.co/docs/packages/tool.typescript/): `workspace:*`
- `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",
  "lint:check": "node ../../../scripts/biome.cjs check .",
  "test": "bun test",
  "typecheck": "tsgo --noEmit"
}
```

## Declared documentation links

- [Integration topology evidence Postgres](https://www.npmjs.com/package/%40lssm-tech%2Fintegration.integration-topology-evidence-postgres) — declared link; destination not verified.

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

## Existing agent-guide projection

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