sql-schema-discovery
CommunityInstantly map SQL Server schemas to Python types.
AuthorWkayaobama
Version1.0.0
Installs0
System Documentation
What problem does it solve?
Manually understanding and documenting complex SQL Server database schemas, including tables, columns, types, and relationships, is tedious and error-prone. This Skill automates schema introspection, providing accurate metadata for dynamic data pipelines, saving you hours of manual investigation.
Core Features & Use Cases
- Dynamic Schema Introspection: Automatically discover tables, columns, data types, nullability, and primary/foreign key relationships from SQL Server.
- SQL to Python Type Mapping: Convert SQL Server data types to their corresponding Python types for seamless integration with Python applications and dataclass generation.
- Use Case: When onboarding a new database or adding a new entity to your data pipeline, use this skill to quickly generate a comprehensive schema overview, enabling rapid development of extraction queries and dataclasses.
Quick Start
Use the sql-schema-discovery skill to discover all tables in the 'CRMICALPS' database and list their names.
Dependency Matrix
Required Modules
pyodbc
Components
scriptsreferences
💻 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: sql-schema-discovery Download link: https://github.com/Wkayaobama/icalps_pipeline/archive/main.zip#sql-schema-discovery Please download this .zip file, extract it, and install it in the .claude/skills/ directory.