skills.rest
canyouseeus
canyouseeusCOMMUNITY
Explore all skills by this author →
GitHub

verify-schema

Identify and report schema and legacy-column mismatches in Supabase databases.

Updated Nov 9, 2025
Search Tags:#database#validation#schema#supabase#data-migration
One-click install
npx skills add https://github.com/canyouseeus/thelostandunfounds --skill verify-schema
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: verify-schema
Source: https://github.com/canyouseeus/thelostandunfounds/tree/main/skills/verify-schema
Command: npx skills add https://github.com/canyouseeus/thelostandunfounds --skill verify-schema

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires @supabase/supabase-js, dotenv, and includes scripts (resource) components.

What problem does it solve?

This skill helps teams ensure database schema integrity and data consistency by validating critical columns and flagging legacy data usage.

Core Features & Use Cases

  • Legacy-column validation: Detects rows where legacy columns are used instead of modern ones.
  • Schema verification: Confirms required columns exist and are in expected types.
  • Migration readiness: Guides data migration efforts and safeguards deployments.

Quick Start

Run the verify-schema script from the project root to validate your database schema and data consistency.

Frequently Asked Questions about verify-schema

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I validate my Supabase database schema before a data migration?▼

To validate your Supabase database schema before a data migration, run a schema verification script from your project root to confirm required columns exist and flag legacy data usage. This ensures data consistency and prevents deployment issues.

How can I detect legacy columns in my Supabase database?▼

Detect legacy columns in your Supabase database by running a schema validation script that identifies rows using outdated columns instead of modern ones. This surfaces actionable warnings to guide your data migration efforts.

Do I need dotenv and supabase-js to check schema health?▼

Yes, checking schema health with this approach requires the dotenv and @supabase/supabase-js dependencies. These packages handle environment variable loading and database connection validation to surface schema mismatch warnings.

Can I run pre-deploy schema checks across staging and production environments?▼

Yes, you can run pre-deploy schema checks across development, staging, and production environments. The validation process connects to your specified environment to report schema mismatches and verify migration readiness.

What is the best way to ensure database schema integrity for a Supabase backend?▼

The best way to ensure database schema integrity for a Supabase backend is to run a schema verification script that validates critical columns, checks expected data types, and flags legacy data usage before deployments.

Related Skills

Explore More Software Engineering Skills→
FindMalekFindMalek
9

prisma-database-setup

Configure Prisma for multiple database providers and set up the client.

Community
Intermediate
MicrockMicrock
322

database-testing

Validate database schemas, constraints, migrations, and transaction isolation.

Community
Intermediate
ogallottiogallotti
1

publicar

Automates end-to-end landing page deployment via GitHub and Netlify CI/CD.

Community
Advanced
wojonswojons
4

testing-database

Test database schemas, migrations, and data integrity with automated scripts.

Community
Intermediate