chameleon introspect

chameleon introspect <database-url> [flags]

chameleon introspect postgresql://user:password@localhost/mydb

ℹ Paranoid Mode active: standard
ℹ Introspecting database...
✓ Database detected
ℹ Scanning tables...
✓ Found 3 table(s)
ℹ Generating schema...
✓ Schema written to schemas/schema.cham

ℹ Next steps:
  1. Review schema and adjust relations manually
  2. Run: chameleon validate
  3. Use with your application

chameleon introspect postgresql://localhost/blog -o blog.cham

✓ Schema written to schemas/blog.cham

export DATABASE_URL="postgresql://user:password@localhost/mydb"
chameleon introspect $DATABASE_URL

chameleon introspect '${DATABASE_URL}'
chameleon introspect env:DATABASE_URL

chameleon introspect postgresql://localhost/mydb --force

✓ Schema written to schemas/schema.cham (overwritten)

CREATE TABLE users (
    id UUID PRIMARY KEY,
    email VARCHAR(255) UNIQUE NOT NULL,
    name VARCHAR(255),
    created_at TIMESTAMP DEFAULT NOW()
);

CREATE TABLE posts (
    id UUID PRIMARY KEY,
    title VARCHAR(255) NOT NULL,
    content TEXT,
    author_id UUID REFERENCES users(id),
    published BOOLEAN DEFAULT FALSE,
    created_at TIMESTAMP DEFAULT NOW()
);

entity User {
    id: uuid primary,
    email: string unique,
    name: string,
    created_at: timestamp default now(),
}

entity Post {
    id: uuid primary,
    title: string,
    content: string,
    author_id: uuid,
    published: bool default false,
    created_at: timestamp default now(),
}

entity User {
    id: uuid primary,
    email: string unique,
    name: string,
    posts: [Post] via author_id,  // Added manually
    created_at: timestamp default now(),
}

entity Post {
    id: uuid primary,
    title: string,
    content: string,
    author_id: uuid,
    author: User,  // Added manually
    published: bool default false,
    created_at: timestamp default now(),
}

chameleon introspect postgresql://localhost/mydb

❌ Read Only Paranoid Mode is active - introspection is blocked

ℹ Mode upgrade available:
   1. Run: chameleon config auth set-password
   2. Run: chameleon config set mode=standard
   3. Retry: chameleon introspect <database-url>

❌ readonly mode: introspect is blocked

# Upgrade mode first
chameleon config set mode=standard

# Now introspection works
chameleon introspect postgresql://localhost/mydb
✓ Schema written to schemas/schema.cham

chameleon introspect postgresql://localhost/mydb

⚠️  Found default schema.cham from 'chameleon init'

ℹ File exists: schemas/schema.cham
Overwrite? (yes/no): yes
✓ Schema written to schemas/schema.cham

chameleon introspect postgresql://localhost/mydb

❌ Found modified schema.cham with custom entities!

⚠️  This appears to be a working schema file

ℹ Existing schema detected: schemas/schema.cham

Options:
  1. Create backup and overwrite (recommended)
  2. Use different output file
  3. Cancel

Choose option (1-3): 1
✓ Backup created: schemas/schema.cham.backup
✓ Schema written to schemas/schema.cham

Choose option (1-3): 2
Enter new output file path: introspected.cham
ℹ Auto-added .cham extension: introspected.cham
ℹ Auto-prefixed with schemas/: schemas/introspected.cham
✓ Schema written to schemas/introspected.cham

# Full URL
chameleon introspect "postgresql://user:password@localhost:5432/dbname"

# Without password (prompts)
chameleon introspect "postgresql://user@localhost/dbname"

# Unix socket
chameleon introspect "postgresql:///dbname?host=/var/run/postgresql"

# SSL mode
chameleon introspect "postgresql://user:pass@host/db?sslmode=require"

# Using $
chameleon introspect $DATABASE_URL

# Using ${}
chameleon introspect '${DATABASE_URL}'

# Using env: prefix
chameleon introspect env:DATABASE_URL

chameleon introspect postgresql://localhost/mydb

❌ failed to connect to database: connection refused

ℹ Check:
   - Database is running
   - Connection string is correct
   - Network connectivity

chameleon introspect mysql://localhost/mydb

❌ failed to detect database type

ℹ Supported:
   - PostgreSQL (postgresql://)
   - MySQL (coming soon)
   - SQLite (coming soon)

chameleon introspect postgresql://localhost/emptydb

✓ Database detected
ℹ Scanning tables...
✓ Found 0 table(s)
ℹ Generating schema...
✓ Schema written to schemas/schema.cham

⚠️  Warning: No tables found in database

// No tables found in database

chameleon introspect postgresql://user@localhost/mydb

❌ failed to scan tables: permission denied

ℹ Ensure database user has SELECT permissions:
   GRANT SELECT ON ALL TABLES IN SCHEMA public TO user;

chameleon introspect postgresql://... -o introspected.cham

# Generate schema
chameleon introspect postgresql://localhost/mydb

# Review changes
cat schemas/schema.cham

# Validate
chameleon validate

# Commit
git add schemas/schema.cham
git commit -m "Add introspected schema"

# .github/workflows/introspect.yml
name: Introspect Database
on:
  schedule:
    - cron: '0 0 * * 0'  # Weekly
jobs:
  introspect:
    runs-on: ubuntu-latest
    steps:
      - uses: actions/checkout@v3
      - name: Introspect
        run: |
          chameleon introspect ${{ secrets.DATABASE_URL }} -o weekly.cham
      - name: Create PR if changes
        run: |
          git diff --exit-code schemas/weekly.cham || \
            gh pr create --title "Schema drift detected"