database-schema-reference

Document SQLite schema with table definitions, indexes, and SQL query patterns.

2|Updated Oct 25, 2025

Search Tags:#database #schema #reference #sqlite #sql #query

Ready to run

npx skills add https://github.com/calevans/staticforge --skill database-schema-reference

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: database-schema-reference
Source: https://github.com/calevans/staticforge/tree/main/.opencode/skills/database-schema-reference
Command: npx skills add https://github.com/calevans/staticforge --skill database-schema-reference

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

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 watchlists and users table 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.

Frequently Asked Questions about database-schema-reference

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

FAQPage Schema

How do I find the SQLite schema definitions for stock-related database tables?▼

You find SQLite schema definitions through detailed CREATE TABLE statements that include columns, data types, constraints, and indexes. This provides a comprehensive view of table structures and their relationships within the database.

How do I write SQL queries to fetch stock data and portfolio values in PHP?▼

You write SQL queries to fetch stock data and portfolio values using practical PHP and SQL query examples provided by the reference. These examples demonstrate common database operations for retrieving financial and user watchlist data.

Do I need to know SQL and PHP to use this database schema reference?▼

Yes, you need knowledge of SQL and PHP for practical application of the database schema reference. This prerequisite knowledge is required to effectively understand the schema and execute the provided query patterns.

What SQL commands are needed for SQLite database maintenance and data cleanup?▼

SQL commands needed for SQLite database maintenance and data cleanup include VACUUM and ANALYZE. The schema reference provides these specific maintenance commands to help optimize and clean up the database.

What is the best way to understand table relationships in an SQLite database?▼

The best way to understand table relationships in an SQLite database is by reviewing detailed schema documentation. This documentation maps out table structures, constraints, and indexes to clarify how different data points connect.

Can I optimize SQL queries for stock applications using a schema reference?▼

Yes, you can optimize SQL queries for stock applications using a schema reference. By understanding table structures and available indexes, you can write more efficient queries for fetching historical prices and portfolio values.