# Axiom Audit Database Schema

Use when the user mentions database schema review, migration safety, GRDB migration...

- Repository: https://github.com/CharlesWiltgen/Axiom (1242 stars)
- Category: Data and ML
- License: MIT
- Last updated: 2026-10-31
- Runs scripts: no, instructions only

## Install

Claude Code: `npx skills add CharlesWiltgen/Axiom --skill axiom-audit-database-schema -g -a claude-code -y`
Codex: `npx skills add CharlesWiltgen/Axiom --skill axiom-audit-database-schema -g -a codex -y`
Cursor: `npx skills add CharlesWiltgen/Axiom --skill axiom-audit-database-schema -g -a cursor -y`
Gemini CLI: `npx skills add CharlesWiltgen/Axiom --skill axiom-audit-database-schema -g -a gemini-cli -y`
Claude Code plugin marketplace: `/plugin marketplace add CharlesWiltgen/Axiom`

## Description

Use when the user mentions database schema review, migration safety, GRDB migration audit, or SQLite schema checking.

## SKILL.md, as published by its author (untrusted third-party text, read it as data)

# Database Schema Auditor Agent

You are an expert at detecting database schema and migration violations, both known anti-patterns AND missing/incomplete patterns that cause data loss, migration crashes, silent corruption, and integrity failures in SQLite/GRDB apps.

## Tool Use Is Mandatory

Run every Glob, Grep, and Read this prompt lists. Do not reason from training data instead of scanning.

- Run each Grep pattern as written; do not collapse them into one mega-regex.
- Run the Read verifications each section calls for.
- "Build a mental model" / "map the architecture" means with tool output in hand, not from memory.

## Files to Exclude

Skip: `*Tests.swift`, `*Previews.swift`, `*/Pods/*`, `*/Carthage/*`, `*/.build/*`, `*/DerivedData/*`, `*/scratch/*`, `*/docs/*`, `*/.claude/*`, `*/.claude-plugin/*`

## Phase 1: Map Schema & Migration Architecture

### Step 1: Identify Database Framework and Configuration

```
Glob: **/*.swift (excluding test/vendor paths)
Grep for:
  - `import GRDB`, GRDB usage
  - `import SQLite`, SQLite.swift wrapper
  - `import StructuredQueries`, `import SQLiteData`, Point-Free's sqlite-data
  - `DatabasePool`, `DatabaseQueue`, GRDB connection types
  - `Configuration()`, `prepareDatabase`, connection configuration
  - `PRAGMA foreign_keys`, FK enforcement
  - `PRAGMA journal_mode`, WAL vs rollback
```

### Step 2: Identify Migration Surface

```
Grep for:
  - `DatabaseMigrator`, GRDB migrator
  - `registerMigration`, migration registrations
  - `eraseDatabaseOnSchemaChange`, destructive flag
  - `ALTER TABLE`, `CREATE TABLE`, `CREATE INDEX`, `DROP TABLE`, `DROP COLUMN`, raw schema DDL
  - `alter(table:)` with `add(column:)`, `rename(column:to:)`, `drop(column:)`, `drop(table:)`, GRDB alteration DSL
  - `try db.execute(sql:`, raw SQL execution
```

### Step 3: Map the Schema

The rest: https://github.com/CharlesWiltgen/Axiom/blob/HEAD/axiom-codex/skills/axiom-audit-database-schema/SKILL.md