comparing-database-schemas

Process use when you need to work with schema comparison. This skill provides database schema diff and sync with comprehensive guidance and automation. Trigger with phrases like "compare schemas", "diff databases", or "sync database schemas".

Ir a la instalación

Repositorio: jeremylongshore/claude-code-plugins-plus-skills
Última actividad en el origen: 17 de julio de 2026 a las 22:18
Idioma detectado de SKILL.md: inglés
Estrellas: 2604
Forks: 378

Opciones de instalación

De forma predeterminada está seleccionado el prompt que primero revisa el origen. Puedes cambiar a un comando directo o descargar una copia local.

Instalar con Codex o Claude Copia este prompt, pégalo en Codex, Claude u otro asistente, y deja que revise la página de la skill y la instale por ti.

Un comando directo omite el prompt de revisión. Revisa el origen antes de ejecutarlo.

npx skills add https://github.com/jeremylongshore/claude-code-plugins-plus-skills --skill comparing-database-schemas

El comando permanece en una sola línea. Desplázate horizontalmente para revisarlo antes de copiarlo.

¿Prefieres una copia local? Descarga los archivos que SkillsMP tiene disponibles ahora.

Revisa los archivos de origen

Lee SKILL.md y los archivos complementarios que muestra SkillsMP antes de decidir si quieres instalarlo.

Explorador de archivos

5 archivos

SKILL.md

Instrucciones de origen · Vista previa de solo lectura

Volver a la búsqueda Volver a la instalación

clerk-core-workflow-a

Implement user sign-up and sign-in flows with Clerk. Use when building authentication UI, customizing sign-in experience, or implementing OAuth social login. Trigger with phrases like "clerk sign-in", "clerk sign-up", "clerk login flow", "clerk OAuth", "clerk social login".

2026-07-23

clerk-core-workflow-b

Implement session management and middleware with Clerk. Use when managing user sessions, configuring route protection, or implementing token refresh and custom JWT templates. Trigger with phrases like "clerk session", "clerk middleware", "clerk route protection", "clerk token", "clerk JWT".

2026-07-23

clerk-enterprise-rbac

Configure enterprise SSO, role-based access control, and organization management. Use when implementing SSO integration, configuring role-based permissions, or setting up organization-level controls. Trigger with phrases like "clerk SSO", "clerk RBAC", "clerk enterprise", "clerk roles", "clerk permissions", "clerk organizations".

2026-07-23

Ver todos los de este repositorio

Database Diff Tool

Overview

Compare database schemas between two environments (development vs. staging, staging vs.

Prerequisites

Connection credentials to both source and target databases

psql or mysql CLI configured to connect to both environments

Read access to information_schema and pg_catalog (PostgreSQL) or information_schema (MySQL)

Permission to run pg_dump --schema-only for full schema extraction

Understanding of which environment is the "source of truth" (typically the migration-managed environment)

Instructions

Extract the full schema from both databases for comparison:

PostgreSQL: pg_dump --schema-only --no-owner --no-privileges -f schema_source.sql source_db and repeat for target_db
MySQL: mysqldump --no-data --routines --triggers source_db > schema_source.sql
Alternatively, query information_schema directly for programmatic comparison

Compare tables present in each database:

SELECT table_name FROM information_schema.tables WHERE table_schema = 'public' AND table_catalog = 'source_db' EXCEPT SELECT table_name FROM information_schema.tables WHERE table_schema = 'public' AND table_catalog = 'target_db'
This reveals tables that exist in source but not in target (and vice versa)

Compare columns for each shared table:

Query information_schema.columns from both databases for: column_name, data_type, character_maximum_length, is_nullable, column_default, ordinal_position
Flag differences in data type, nullability, default values, and column ordering
Detect added columns (in source, not target) and dropped columns (in target, not source)

Compare indexes:

PostgreSQL: Query pg_indexes for indexname, indexdef on each database
MySQL: Query information_schema.STATISTICS for INDEX_NAME, COLUMN_NAME, NON_UNIQUE

Database Diff Tool

Overview

Compare database schemas between two environments (development vs. staging, staging vs.

Prerequisites

Connection credentials to both source and target databases

psql or mysql CLI configured to connect to both environments

Read access to information_schema and pg_catalog (PostgreSQL) or information_schema (MySQL)

Permission to run pg_dump --schema-only for full schema extraction

Understanding of which environment is the "source of truth" (typically the migration-managed environment)

Instructions

Extract the full schema from both databases for comparison:

PostgreSQL: pg_dump --schema-only --no-owner --no-privileges -f schema_source.sql source_db and repeat for target_db
MySQL: mysqldump --no-data --routines --triggers source_db > schema_source.sql
Alternatively, query information_schema directly for programmatic comparison

Compare tables present in each database:

SELECT table_name FROM information_schema.tables WHERE table_schema = 'public' AND table_catalog = 'source_db' EXCEPT SELECT table_name FROM information_schema.tables WHERE table_schema = 'public' AND table_catalog = 'target_db'
This reveals tables that exist in source but not in target (and vice versa)

Compare columns for each shared table:

Query information_schema.columns from both databases for: column_name, data_type, character_maximum_length, is_nullable, column_default, ordinal_position
Flag differences in data type, nullability, default values, and column ordering
Detect added columns (in source, not target) and dropped columns (in target, not source)

Compare indexes:

PostgreSQL: Query pg_indexes for indexname, indexdef on each database
MySQL: Query information_schema.STATISTICS for INDEX_NAME, COLUMN_NAME, NON_UNIQUE

name	comparing-database-schemas
description	Process use when you need to work with schema comparison. This skill provides database schema diff and sync with comprehensive guidance and automation. Trigger with phrases like "compare schemas", "diff databases", or "sync database schemas".
allowed-tools	Read, Write, Edit, Grep, Glob, Bash(psql:), Bash(mysql:), Bash(mongosh:*)
version	1.27.0
author	Jeremy Longshore <jeremy@intentsolutions.io>
license	MIT
tags	["database","comparing-database"]
compatibility	Designed for Claude Code, also compatible with Codex and OpenClaw

name	comparing-database-schemas
description	Process use when you need to work with schema comparison. This skill provides database schema diff and sync with comprehensive guidance and automation. Trigger with phrases like "compare schemas", "diff databases", or "sync database schemas".
allowed-tools	Read, Write, Edit, Grep, Glob, Bash(psql:), Bash(mysql:), Bash(mongosh:*)
version	1.27.0
author	Jeremy Longshore <jeremy@intentsolutions.io>
license	MIT
tags	["database","comparing-database"]
compatibility	Designed for Claude Code, also compatible with Codex and OpenClaw

Error	Cause	Solution
Connection refused to one database	Network or credential issue on source or target	Verify connection strings; check firewall rules; confirm credentials work with direct `psql` or `mysql` connection
Permission denied on `pg_catalog` queries	User lacks read access to system catalogs	Grant `pg_read_all_settings` role; or use `pg_dump --schema-only` which requires fewer privileges
False positive differences from default value formatting	PostgreSQL normalizes default expressions differently in different versions	Normalize default value strings before comparison; ignore whitespace differences; compare semantic equivalence
Enum type modification blocked	PostgreSQL does not support removing enum values or reordering	Create a new enum type, migrate the column, drop the old type; document this as a multi-step migration
Generated migration fails on target	Target has data that violates new constraints	Add data validation queries before constraint creation; backfill default values; handle edge cases in migration

comparing-database-schemas

Opciones de instalación

Revisa los archivos de origen

Database Diff Tool

Overview

Prerequisites

Instructions

Database Diff Tool

Overview

Prerequisites

Instructions

Output

Error Handling

Examples

Resources

comparing-database-schemas

Datos de origen

Opciones de instalación

Revisa los archivos de origen

Más de este repositorio

Database Diff Tool

Overview

Prerequisites

Instructions

Más de este repositorio

Database Diff Tool

Overview

Prerequisites

Instructions

Output

Error Handling

Examples

Resources