What problem does it solve? Operating on the awid.ai production database requires locating credentials, using the correct Neon Postgres connection string and schema name, and following safe procedures for migrations, audits, and schema consolidation without corrupting production data. ## Core Features & Use Cases - Credential and Connection Guidance: Locates production credentials in .env.awid-production and connects via psql using the AWID_DATABASE_URL Neon Postgres string with the awid schema. - Audit and Integrity Queries: Provides ready-made SQL for table counts across did_aw_mappings, dns_namespaces, public_addresses, teams, and team_certificates, plus orphan address detection before adding FK constraints. - Migrations and Schema Consolidation: Runs migrations through the AwidDatabaseInfra Python module and documents the full dump-transform-drop-migrate-load-verify workflow used for the awid 0.3.1 consolidation. - Use Case: Before deploying a migration that adds a foreign key constraint, run the orphan address query to find public_addresses rows with no matching did_aw_mappings entry, then verify table counts after the migration completes. ## Quick Start Connect to the awid.ai production database and run the table count audit query to verify the current state of the registry.
