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 para a instalação

Repositório: jeremylongshore/claude-code-plugins-plus-skills
Última atividade na origem: 17 de julho de 2026 às 22:18
Idioma detectado do SKILL.md: inglês
Estrelas: 2.604
Forks: 378

Opções de instalação

Por padrão, está selecionado o prompt que primeiro revisa a origem. Você pode mudar para um comando direto ou baixar uma cópia local.

Instalar com Codex ou Claude Copie este prompt, cole no Codex, Claude ou outro assistente e deixe que ele revise a página da skill e instale para você.

Um comando direto ignora o prompt de revisão. Verifique a origem antes de executá-lo.

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

O comando permanece em uma só linha. Role horizontalmente para revisá-lo antes de copiar.

Prefere uma cópia local? Baixe os arquivos disponíveis atualmente no SkillsMP.

Revise os arquivos de origem

Leia o SKILL.md e os arquivos complementares exibidos pelo SkillsMP antes de decidir se vai instalar.

Explorador de arquivos

5 arquivos

SKILL.md

Instruções da origem · Visualização somente leitura

Voltar à pesquisa Voltar à instalação

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 todas deste repositório

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

Opções de instalação

Revise os arquivos de origem

Database Diff Tool

Overview

Prerequisites

Instructions

Database Diff Tool

Overview

Prerequisites

Instructions

Output

Error Handling

Examples

Resources

comparing-database-schemas

Informações da origem

Opções de instalação

Revise os arquivos de origem

Mais deste repositório

Database Diff Tool

Overview

Prerequisites

Instructions

Mais deste repositório

Database Diff Tool

Overview

Prerequisites

Instructions

Output

Error Handling

Examples

Resources