skills.rest
linhlvit
linhlvitCOMMUNITY
Explore all skills by this author →
GitHub

source-survey

Survey Oracle source databases and export CSV, ER diagram, and BRD YAML artifacts.

1|Updated Apr 7, 2026
Search Tags:#data modeling#er diagram#csv export#source survey#oracle mcp#brd yaml#schema reconciliation
One-click install
npx skills add https://github.com/linhlvit/ubck_atomic_design --skill source-survey
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: source-survey
Source: https://github.com/linhlvit/ubck_atomic_design/tree/main/.claude/skills/source-survey
Command: npx skills add https://github.com/linhlvit/ubck_atomic_design --skill source-survey

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Manually surveying source database structures, reconciling design documentation with live schemas, and generating consistent design artifacts is time-consuming, error-prone, and requires deep knowledge of multiple tooling and formatting standards. This skill eliminates that manual overhead for data modelers working on Oracle-based data lakehouse projects.

Core Features & Use Cases

  • Full Source Survey: Automatically extract table lists, column definitions, comments, and foreign key constraints from Oracle source databases via MCP to generate standardized UTF-8 CSV files for tables and columns.
  • Reconcile Mode: Compare existing design CSV files against live database schemas without overwriting original documentation, flagging table mismatches, unconfirmed foreign keys, and schema conflicts for resolution before LLD work begins.
  • Interactive ER Diagram Generation: Create filterable, zoomable HTML ER diagrams grouped by business function, with BRD scope badges, foreign key line highlighting, and drag-and-drop layout persistence for team collaboration.
  • BRD Source YAML Generation: Auto-generate compliant BRD Source YAML files with inferred functional groups, ingestion modes, and related table mappings, plus per-table column YAML files aligned with project schemas.
  • Use Case: For a data modeler onboarding a new Oracle source system for the UBCK lakehouse project, use this skill to run a full survey to produce initial CSV documentation, ER diagrams, and BRD YAML files in a single workflow.

Quick Start

Use the source-survey skill to run a full survey of the NHNCK Oracle source system, export standardized table and column CSV files, generate an interactive ER diagram, and produce the corresponding BRD Source YAML artifacts.

Frequently Asked Questions about source-survey

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I automate an Oracle database schema survey and export table metadata to CSV?▼

Automate an Oracle database schema survey by connecting to the source database to automatically extract table lists, column definitions, comments, and foreign key constraints into standardized UTF-8 CSV exports.

How do I reconcile existing design documentation against a live Oracle database schema?▼

Reconcile design documentation against a live Oracle schema using reconcile mode to compare existing design CSV files with the live database, flagging table mismatches and unconfirmed foreign keys without overwriting original documentation.

What is the best way to generate an interactive ER diagram from an Oracle database?▼

Generate an interactive HTML ER diagram from an Oracle database by automatically extracting schema metadata to create filterable, zoomable diagrams grouped by business function with drag-and-drop layout persistence.

Can I auto-generate BRD Source YAML files directly from Oracle source database metadata?▼

Yes, auto-generate compliant BRD Source YAML files directly from Oracle metadata, complete with inferred functional groups, ingestion modes, related table mappings, and per-table column YAML outputs.

Does the source survey workflow support validating schema changes before starting low-level design work?▼

Yes, the reconcile mode validates schema changes by comparing live database schemas against existing design CSVs, flagging conflicts and unconfirmed foreign keys for resolution before low-level design work begins.

How do I generate interactive HTML ER diagrams from Oracle database metadata?▼

Generate interactive HTML ER diagrams from Oracle database metadata by extracting foreign key constraints and table definitions to create filterable, zoomable visualizations grouped by business function with BRD scope badges and layout persistence.

Related Skills

Explore More Data & Analytics Skills→
diegoliriodiegolirio

setup-db-mcp

Configure MCP servers for database connectivity from a connection string.

Community
Advanced
neo4j-contribneo4j-contrib
101

neo4j-import-skill

Import structured CSV, JSON, and bulk datasets into Neo4j.

Official
Advanced
lance-doniflance-donif

data-model-creation

Generate Mermaid class diagrams for visual data relationship modeling.

Community
Advanced
marlo9981marlo9981

schema-exploration

List tables, describe columns and data types, and identify foreign keys.

Community
Intermediate