skills.rest
bharthraj1412
bharthraj1412COMMUNITY
Explore all skills by this author →
GitHub

schema-exploration

List database tables, columns, keys, and relationships via system catalogs.

Updated Apr 12, 2026
Search Tags:#database#schema#queries#sql#exploration#relationships#tables
One-click install
npx skills add https://github.com/bharthraj1412/myai --skill schema-exploration-bharthraj1412
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: schema-exploration
Source: https://github.com/bharthraj1412/myai/tree/main/vendor/deepagents/examples/text-to-sql-agent/skills/schema-exploration
Command: npx skills add https://github.com/bharthraj1412/myai --skill schema-exploration-bharthraj1412

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Understanding and documenting database schemas quickly by listing tables, columns, keys, and relationships to accelerate data discovery and query planning.

Core Features & Use Cases

  • List all tables in a database and show key attributes
  • Inspect table schemas with column names, data types, primary and foreign keys
  • Map relationships across tables to reveal foreign-key chains
  • Use for data discovery, impact analysis, and query planning

Quick Start

Ask me to map a database schema by listing all tables, their columns, and the relationships between them.

Frequently Asked Questions about schema-exploration

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

FAQPage Schema
How do I list all tables and columns in a database schema?▼

To map database relationships, you inspect foreign keys and primary keys across tables to reveal foreign-key chains. This maps how tables connect, providing essential context for query planning and impact analysis.

What is the best way to map table relationships across a database?▼

To map database relationships, you inspect foreign keys and primary keys across tables to reveal foreign-key chains. This maps how tables connect, providing essential context for query planning and impact analysis.

How does database schema exploration help with query planning?▼

Database schema exploration accelerates query planning by revealing table schemas, column data types, and sample records. Understanding these relationships allows you to structure joins accurately and avoid misaligned data retrieval.

Can I retrieve sample records when inspecting a database schema?▼

Yes, you can retrieve sample records when inspecting a database schema. The schema-inspection workflow queries system catalogs and returns organized metadata including sample records to provide immediate context for data discovery.

Does this schema exploration workflow require any specific database dependencies?▼

No specific database dependencies are required. The schema exploration workflow applies across typical database schemas by querying standard system catalogs to return organized metadata like keys and column data types.

Related Skills

Explore More Data & Analytics Skills→
Gundlapuriswathiii006Gundlapuriswathiii006

database

Execute parameterized read-only SQL queries against Replit PostgreSQL databases.

Community
Intermediate
EvolutionAPIEvolutionAPI
520

data-write-query

Translate natural-language data requests into optimized PostgreSQL SQL queries.

Official
Advanced
marlo9981marlo9981

schema-exploration

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

Community
Intermediate
sahiixxsahiixx
2

schema_exploration

List database tables, detail columns, and map foreign-key relationships.

Community
Basic