sql-schema-discovery

Name: sql-schema-discovery
Availability: InStock
Author: wkayaobama

Discover SQL Server database tables, columns, types, and key relationships.

Updated Aug 23, 2026

One-click install

npx skills add https://github.com/Wkayaobama/icalps_pipeline --skill sql-schema-discovery

Or copy as Structured Prompt for Agent▼

Please help me install this Agent Skill.
Skill: sql-schema-discovery
Source: https://github.com/Wkayaobama/icalps_pipeline/tree/main/Documents/AnthonySalesOps/Codebase/IC_Load/sql-schema-discovery
Command: npx skills add https://github.com/Wkayaobama/icalps_pipeline --skill sql-schema-discovery

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires pyodbc, and includes scripts (resource) and references (resource) components.

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.