analyze-schema
CommunityMap schemas, dependencies, and data volumes.
Data & Analytics#PostgreSQL#topological sort#Neo4j#data discovery#database mapping#ETL planning#schema analysis#dependency graph
Authorpauljbernard
Version1.0.0
Installs0
System Documentation
What problem does it solves? Manually mapping complex database schemas and dependencies across multiple data stores is a time-consuming and error-prone task. This Skill automates the entire discovery process, providing a clear, actionable understanding of your data landscape.
Core Features & Use Cases
- Multi-Database Schema Extraction: Connects to various databases (PostgreSQL, Neo4j) to extract detailed schema information, including tables, columns, primary/foreign keys, and indexes.
- Automated Dependency Graphing: Builds a comprehensive dependency graph, identifies circular dependencies, and generates a topologically sorted extraction order.
- Use Case: Before initiating any data migration or integration project, use this Skill to autonomously generate a complete schema analysis, including a visual dependency graph and a safe extraction order, ensuring data integrity and preventing issues during transfers.
Quick Start
Analyze the schemas of all 5 data stores (IDS, HCP1, HCP2, ADB, SP) and generate a dependency graph and extraction order.
Dependency Matrix
Required Modules
pandasneo4j-driversqlalchemypsycopg2-binary
Components
scripts
💻 Claude Code Installation
Recommended: Let Claude install automatically. Simply copy and paste the text below to Claude Code.
Please help me install this Skill: Name: analyze-schema Download link: https://github.com/pauljbernard/datamig/archive/main.zip#analyze-schema Please download this .zip file, extract it, and install it in the .claude/skills/ directory.
Agent Skills Search Helper
Install a tiny helper to your Agent, search and equip skill from 223,000+ vetted skills library on demand.