schema

Name: schema
Availability: InStock
Author: wangzitian0

Define PostgreSQL database schemas with table structures, relationships, and migration rules.

Updated Jun 5, 2025

Search Tags:#database #postgresql #schema #migration #sqlalchemy #alembic

Ready to run

npx skills add https://github.com/wangzitian0/finance_report --skill schema-wangzitian0

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: schema
Source: https://github.com/wangzitian0/finance_report/tree/main/.opencode/skills/domain/schema
Command: npx skills add https://github.com/wangzitian0/finance_report --skill schema-wangzitian0

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

This Skill provides a clear definition of the PostgreSQL database schema, including table structures, relationships, and migration rules, ensuring consistency and maintainability in database development.

Core Features & Use Cases

Database Schema Definition: Understand core table structures and relationships for users, accounts, journal entries, and more.
Design Constraints: Adhere to naming conventions, migration length limits, and recommended patterns for robust database design.
Use Case: When developing new features that interact with financial data, consult this Skill to understand the existing table structures and ensure your new code aligns with the established schema and best practices.

Quick Start

Explain the purpose of the 'JournalEntries' table in the database schema.

Frequently Asked Questions about schema

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

FAQPage Schema

How do I define a PostgreSQL database schema with SQLAlchemy and Alembic?▼

To define a PostgreSQL database schema with SQLAlchemy and Alembic, detail table structures, relationships, and migration rules while enforcing naming conventions and async session management for maintainable database development.

What data type should I use for monetary values in a PostgreSQL schema?▼

For monetary values in a PostgreSQL schema, you should use the DECIMAL data type. This recommended pattern ensures precise financial calculations and prevents floating point errors in journal entries and account balances.

How do I manage Alembic migration rules for an existing PostgreSQL database?▼

Manage Alembic migration rules by adhering to established migration length limits and naming conventions. This ensures new database schema changes align with the existing table structures and maintain robust database design.

Does this database schema definition support async session management?▼

Yes, this database schema definition supports async session management. It applies to SQLAlchemy model development and enforces recommended patterns, ensuring your code aligns with established table structures during async database operations.

When do I need to consult database schema definitions for financial data features?▼

Consult database schema definitions when developing new features interacting with financial data. Understanding existing table structures, such as the JournalEntries table, ensures your code aligns with established schema and best practices.

What are the core table structures in a PostgreSQL schema for financial applications?▼

Core PostgreSQL schema table structures for financial applications include users, accounts, and journal entries. These tables define relationships and migration rules to ensure consistency and maintainability in database development.