skills.rest
Hmbown
HmbownCOMMUNITY
Explore all skills by this author →
Website𝕏@goodhuntGitHub

schema_exploration

List database tables and detail columns, data types, and relationships.

50|4|Updated Feb 16, 2026
Search Tags:#database#schema#sql#relationships#tables#columns
One-click install
npx skills add https://github.com/Hmbown/rlmagents --skill schema-exploration-hmbown
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: schema_exploration
Source: https://github.com/Hmbown/rlmagents/tree/main/examples/text-to-sql-agent/skills/schema-exploration
Command: npx skills add https://github.com/Hmbown/rlmagents --skill schema-exploration-hmbown

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This Skill helps users understand the structure of a database, including tables, columns, data types, and relationships, making it easier to query and analyze data.

Core Features & Use Cases

  • List All Tables: Provides a comprehensive list of all available tables in the database.
  • Get Table Schema: Details column names, data types, primary keys, and foreign keys for specific tables.
  • Map Relationships: Helps identify how different tables are connected through foreign keys.
  • Use Case: A data analyst needs to understand the available data in a new database. They use this skill to list all tables, then inspect the schema of relevant tables to plan their queries.

Quick Start

Use the schema exploration skill to list all tables in the database.

Frequently Asked Questions about schema_exploration

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

FAQPage Schema
How do I explore a database schema to understand tables and columns?▼

You can explore a database schema by listing all available tables and inspecting their columns, data types, primary keys, and foreign keys. This maps the database structure to help plan queries and analyze data.

What is the best way to map relationships between SQL database tables?▼

Map SQL database relationships by identifying foreign keys within table schemas. This clarifies how different tables connect through keys, making it easier to navigate relational data and write accurate join queries.

How do I list all tables in a database for data analysis?▼

List all tables in a database to get a comprehensive inventory of available data structures. This provides the overview needed to identify which specific tables are relevant for your data analysis tasks.

Do I need SQL database access to inspect table schemas and data types?▼

Yes, you need SQL database access and tools for schema introspection to inspect table schemas. This direct access is required to retrieve metadata detailing column names, data types, and table relationships.

How do I get table schema details like primary keys and foreign keys?▼

Get table schema details by inspecting specific tables within the database. This details exact column names, data types, and identifies both primary and foreign keys, clarifying structural constraints for query planning.

Related Skills

Explore More Data & Analytics Skills→
fcakyonfcakyon
1.0k

supabase-usage

Query Supabase databases to list tables, inspect schemas, and explore relationships.

Community
Advanced
marlo9981marlo9981

schema-exploration

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

Community
Intermediate
myrtlepnmyrtlepn
24

schema-designer

Design database schemas, ERDs, and migration plans for software features.

Community
Advanced
AstyanMAstyanM
1

dbml

Design and visualize database schemas as DBML files.

Community
Intermediate