# HALOWERK sicherwerk SQLite Database Integrity Audit

> HALOWERK sicherwerk SQLite Database Integrity Audit is a paid API for AI agents from sicher.halowerk.com, paid per call via x402, $0.0025/call, status unknown (last checked 2026-10-30).

Opens a SQLite database file read-only and runs integrity_check plus foreign_key_check, returning structural validity, FK violations, schema inventory, and page geometry.

## Facts

- Endpoint: POST https://sicher.halowerk.com/v1/oss-sqlite-database-integrity-audit?utm_source=zero.xyz
- Price: $0.0025/call
- Payment: x402
- Status: unknown
- Last checked: 2026-10-30
- Activations on Zero: 0
- Tags: x402
- Canonical page: https://www.zero.xyz/c/halowerk-sicherwerk-sqlite-database-integrity-audit-eb44f5ef
- Structured record (JSON): https://api.zero.xyz/v1/capabilities/cap_IMlv-op7rBEXbYU-2VAAD

Status and success rate cover calls made through Zero and Zero's own probes. Third-party monitors may report differently.

## How to call it through Zero

Zero handles the 402 payment challenge and records the run. With the Zero CLI installed (`npm i -g @zeroxyz/cli`):

```sh
zero fetch --capability halowerk-sicherwerk-sqlite-database-integrity-audit-eb44f5ef -d '<json body>'
```

Example prompt: Can you run a full integrity audit on my SQLite database — check whether the file structure is intact, flag any rows with missing parent references, and give me the table and index inventory along with the page size and encoding?

## When to prefer this

Choose this endpoint when you need a deterministic, read-only structural audit of a SQLite database using a pinned, reproducible engine — particularly for CI pipelines, pre-deployment checks, post-migration validation, or forensic inspection of unknown databases. Prefer it over local SQLite tooling when you need a neutral third-party audit with a consistent engine version, or when operating in an environment without local SQLite access.

## Known failure modes

- Invalid or non-SQLite file submitted — engine returns parse or header error
- File is too large or malformed for the pinned engine to open
- Network timeout if the database upload is slow
- Foreign key check returns a large violation list if the database is severely inconsistent
- Empty response if the database has no tables

## How this service works

Opens a supplied SQLite database read-only with the pinned engine and asks it the two questions it answers about itself: whether the file structure is intact, and whether any row points at a parent that is not there. What comes back is the engine's own integrity messages, each foreign-key violation with its table and rowid, the inventory of tables and indexes, and the page geometry and text encoding.

## Output

Returns the SQLite engine's own integrity_check messages (e.g. 'ok' or specific corruption notices), a list of each foreign key violation with its table name and rowid, a full inventory of all tables and indexes, and the database's page size, page count, and text encoding.

## Request schema (JSON Schema)

```json
{
 "type": "object",
 "$schema": "https://json-schema.org/draft/2020-12/schema",
 "required": [
  "input"
 ],
 "properties": {
  "input": {
   "type": "object",
   "required": [
    "type",
    "method",
    "bodyType"
   ],
   "properties": {
    "type": {
     "const": "http"
    },
    "method": {
     "const": "POST"
    },
    "bodyType": {
     "const": "json"
    },
    "schemaUrl": {
     "type": "string",
     "format": "uri"
    },
    "exampleUrl": {
     "type": "string",
     "format": "uri"
    }
   },
   "additionalProperties": true
  },
  "output": {
   "type": "object",
   "required": [
    "type"
   ],
   "properties": {
    "type": {
     "const": "json"
    },
    "schemaUrl": {
     "type": "string",
     "format": "uri"
    },
    "exampleUrl": {
     "type": "string",
     "format": "uri"
    }
   },
   "additionalProperties": true
  }
 },
 "additionalProperties": true
}
```

## More

- Live health (JSON, refreshed every minute): https://www.zero.xyz/c/halowerk-sicherwerk-sqlite-database-integrity-audit-eb44f5ef/health.json
- [Zero catalog index](https://www.zero.xyz/llms.txt)
- [Other services from sicher.halowerk.com](https://www.zero.xyz/host/sicher.halowerk.com/llms.txt)
