Getting it into your agent
One page per mod, every tool's command on it. A separate URL per tool would split the same page into five that compete with each other.
npx agentmods add agents/eddiebelaval/squire/database-migration-specialistgit clone --depth 1 https://github.com/eddiebelaval/squireWrote this? Show the measurements
A badge with what this costs and how it scanned, read live from this page, so it follows the numbers instead of freezing them. Markdown for a README, HTML for a documentation site or a project page.
[](https://agentmods.dev/agents/eddiebelaval/squire/database-migration-specialist)<a href="https://agentmods.dev/agents/eddiebelaval/squire/database-migration-specialist"><img src="https://agentmods.dev/badge/agents/eddiebelaval/squire/database-migration-specialist.svg" alt="Measured on agentmods" height="20"></a>What it costs to keep this loaded
Counted locally with the o200k_base tokenizer, which is exact for GPT models; Claude uses its own tokenizer and its counts differ. Treat this as one consistent yardstick across the catalogue rather than a bill. Prices are per million input tokens.
| Model | Per session | Once invoked |
|---|---|---|
| Fable 5 | $0.00009 | $0.01304 |
| Opus 5 | $0.00005 | $0.00652 |
| Sonnet 5 | $0.00002 | $0.00261 |
| Haiku 4.5 | $0.00001 | $0.00130 |
Grade A, and why
database-migration-specialist scanned grade A with 0 findings against 26 rules in 11 categories — prompt injection, anti-refusal, data exfiltration, privilege escalation, supply chain, agent snooping, system-prompt leakage, SSRF and excessive agency — measured 4d ago.
A static scan of the body, not an audit. Every finding is printed with the line that produced it so you can judge whether it matters here. A mod is markdown that instructs an agent; that is exactly why what it instructs is worth reading.
Nothing flagged
None of the 26 patterns this scan looks for appear in this file: no shell pipes, no recursive deletes, no credential paths, no hidden text, no instruction-override or anti-refusal phrasing, no agent-config snooping. That is not a guarantee, it is the absence of the things that are checkable.
How it starts
The opening of the file, as written. The whole thing — 167 lines — stays where its author put it; the contents beside it link to each section on GitHub.
Database Migration Specialist
You are an expert database engineer specializing in PostgreSQL, Supabase, schema migrations, and zero-downtime deployments. Your mission is to fix the tier naming inconsistency in the id8composer database.
Your Expertise
- PostgreSQL schema design and migrations
- Supabase RLS policies and functions
- Data integrity and constraint management
- Zero-downtime migration strategies
- Rollback procedures
Current Assignment: Fix STUDIO → ENTERPRISE Tier Mismatch
Problem Analysis
Current State:
- Database migration
/Users/eddiebelaval/Development/id8/id8composer-rebuild/supabase/migrations/20251030_create_subscriptions_table.sqlline 23 uses "STUDIO" tier - Application code uses "ENTERPRISE" tier
- This mismatch will cause INSERT failures and tier confusion
Impact:
- New subscriptions cannot be created with ENTERPRISE tier
- Tier checks may fail
- Data inconsistency between code and database
Your Solution
Task 1: Create Migration to Fix Tier Naming
Create: /Users/eddiebelaval/Development/id8/id8composer-rebuild/supabase/migrations/20251110_fix_tier_naming.sql
Migration Contents:
-- Migration: Fix tier naming STUDIO → ENTERPRISE
-- Date: 2025-11-10
-- Purpose: Align database schema with application code
BEGIN;
-- Step 1: Drop the old constraint
ALTER TABLE public.subscriptions
DROP CONSTRAINT IF EXISTS subscriptions_tier_check;
-- Step 2: Update any existing STUDIO records to ENTERPRISE
UPDATE public.subscriptions
SET tier = 'ENTERPRISE'
WHERE tier = 'STUDIO';
-- Step 3: Add the corrected constraint
ALTER TABLE public.subscriptions
ADD CONSTRAINT subscriptions_tier_check
CHECK (tier IN ('FREE', 'PRO', 'ENTERPRISE'));
-- Step 4: Add comment documenting the change
COMMENT ON COLUMN public.subscriptions.tier IS
'Subscription tier: FREE, PRO, or ENTERPRISE (formerly STUDIO)';
COMMIT;
Task 2: Search and Replace Code References
Search for: Any remaining "STUDIO" references in codebase
What this file has done since we first saw it
Hashed on every crawl. A supply-chain change to an agent config is a question of when, not whether, so the history is kept rather than the latest state alone.
- 4d ago First seen · 167 lines · 9 tokens per session scan A 9b7f28d4989b
database-migration-specialist is an agent published in the GitHub repository eddiebelaval/squire (21 stars, last pushed 19d ago), licensed MIT. It adds 9 tokens to every session and 1,304 once invoked, about $0.0000 per session on Opus 5. A static security scan graded it A with 0 findings. No closer match exists in the catalogue, so it is treated as the original; first seen 2026-08-30.
Other agents, from other repositories
database
The Database agent is the specialist for everything below the API layer: schema design, data modeling, migration creation, query optimization, and storage strategy. It knows that schema design is not just about tables and columns -- it is about encoding business rules into constraints, choosing normalization levels…
database-expert
Expert database architect specializing in schema design, query optimization, data modeling, and migration strategies. Japanese: データベースエキスパート.
performance-profiling-coach
Use this agent when you need performance analysis and optimization guidance for code. Trigger this agent proactively after implementing computationally intensive features, database queries, loops, or algorithms. Examples:\n\n \nContext: User just implemented a creature AI update function that processes all nearby…
security-audit-assistant
Use this agent when you need to perform security audits on code, especially after implementing authentication, database queries, user input handling, cryptographic operations, or any code that processes untrusted data. This agent should be used proactively during code reviews and before deployment to identify…
test-engineer
Creates comprehensive test suites, fixes failing tests, maintains coverage, and auto-fixes database isolation and SQLAlchemy issues.
security-auditor
Security vulnerability scanner for OWASP Top 10, SQL injection, XSS, auth issues, dependencies, cryptography, and architectural vulnerabilities.