database-schema-reference
CommunityUnderstand and query your database schema.
Authorcalevans
Version1.0.0
Installs0
System Documentation
What problem does it solve?
This Skill provides a comprehensive reference to the application's SQLite database schema, enabling users to understand table structures, relationships, and write effective SQL queries.
Core Features & Use Cases
- Schema Documentation: Detailed CREATE TABLE statements for all tables, including columns, data types, constraints, and indexes.
- Query Examples: Practical PHP and SQL examples for common operations like fetching stock data, portfolio values, and historical prices.
- Maintenance Guidance: SQL commands for database maintenance tasks like VACUUM, ANALYZE, and data cleanup.
- Use Case: A developer needs to add a new feature that requires querying user watchlists. They can use this Skill to quickly find the
watchlistsanduserstable schemas and relevant query patterns.
Quick Start
Use the database-schema-reference skill to find the SQL query for retrieving a user's watchlist with current stock prices.
Dependency Matrix
Required Modules
None requiredComponents
references
💻 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: database-schema-reference Download link: https://github.com/calevans/staticforge/archive/main.zip#database-schema-reference Please download this .zip file, extract it, and install it in the .claude/skills/ directory.
Agent Skills Search Helper
Install a tiny helper to your Agent, search and equip skill from 223,000+ vetted skills library on demand.