{"uid":"cap_IMlv-op7rBEXbYU-2VAAD","slug":"halowerk-sicherwerk-sqlite-database-integrity-audit-eb44f5ef","name":"HALOWERK sicherwerk SQLite Database Integrity Audit","description":"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.","url":"https://sicher.halowerk.com/v1/oss-sqlite-database-integrity-audit?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"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},"responseSchema":null,"example":null,"exampleRequest":null,"tags":["x402"],"displayCostAmount":"0.0025","displayCostAsset":"USDC","priceDynamic":false,"priceHint":null,"priceStatus":"priced","priceSource":"probe","requiresHandshake":false,"reviewCount":0,"rating":{"score":"0.00","successRate":"0.00","reviews":0,"stars":null,"state":"unrated"},"availabilityStatus":"unknown","priceObserved":null,"sessionDeposit":null,"pricing":{"kind":"static","summary":"$0.0025/call","primary":{"kind":"static","protocol":"x402","network":"base","amountUsd":"0.0025","per":"call","confidence":"exact"},"accepted":[{"kind":"static","protocol":"x402","network":"base","amountUsd":"0.0025","per":"call","confidence":"exact"}]},"paymentMethods":[{"uid":"pm_YZ8cw5sRkSNIBuO0FSSvh","protocol":"x402","methodType":"crypto","chain":"base","mode":"charge","costAmount":"0.0025","costPer":"request","priority":0,"asset":"0x833589fCD6eDb6E08f4c7C32D4f71b54bdA02913","unit":"request","depositMicros":null,"planRef":null}],"brandName":null,"brandSlug":null,"brandBaseUrl":null,"brandDocsUrl":null,"whatItDoes":"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.","exampleAgentPrompt":"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?","exampleUseCases":[{"title":"Pre-deployment database health check","prompt":"Before I ship this release, can you audit my SQLite database file to make sure there's no corruption and all foreign key references are valid? I need to know about any structural issues before it goes to production."},{"title":"Diagnosing orphaned records after a migration","prompt":"I just ran a data migration on my SQLite database and I'm worried some rows ended up pointing to parents that no longer exist — can you run a foreign key check and tell me exactly which tables and row IDs have violations?"},{"title":"Forensic schema inspection of an unknown database","prompt":"I've got a SQLite file from a legacy app and I have no docs for it — can you open it read-only and give me the full inventory of tables and indexes, plus the page geometry and text encoding so I understand what I'm working with?"}],"resultDescription":"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.","failureModes":["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"],"whenToPreferThis":"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.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-30T12:31:04.858Z","isFirstParty":false,"canonicalSlug":"halowerk-sicherwerk-sqlite-database-integrity-audit-eb44f5ef"}