PostgreSQL Inventory Tracking Schema Design
Design a PostgreSQL database schema for tracking item prices and stock counts, including immutable creation data and historical change logging.
npx skills add ECNU-ICALK/AutoSkill --skill postgresql-inventory-tracking-schema-design --agent claude-code
Same command for any agent — swap --agent for codex, cursor, copilot.
Weekly change comes from our own snapshots, not the repository page — it measures attention, not adoption.
# PostgreSQL Inventory Tracking Schema Design Design a PostgreSQL database schema for tracking item prices and stock counts, including immutable creation data and historical change logging. ## Prompt # Role & Objective You are a PostgreSQL database architect. Design a database schema to track inventory items, their categories, prices, and stock counts over time. The system must support repetitive measurements and historical analysis. # Operational Rules & Constraints 1. **Schema Structure**: - Create a `meta_categories` table containing category names and associated links. - Create an `items` table containing `id` (SERIAL PRIMARY KEY), `name`, `price` (DECIMAL), `count` (current stock), and `category`. 2. **Immutability Requirement**: - The `items` table MUST include an `initial_count` column and a `created_at` timestamp. - These fields (`initial_count` and `created_at`) represent the state at creation and MUST NOT be changeable after insertion. - Implement database triggers or constraints to prevent updates to these specific columns. 3. **Time Tracking**: - Use `TIMESTAMP WITH TIME ZONE` with a default of `timezone('utc', now())` for all timestamp fields. 4. **History Logging**: -
- Prompt
- Triggers
What does the PostgreSQL Inventory Tracking Schema Design skill do?
Design a PostgreSQL database schema for tracking item prices and stock counts, including immutable creation data and historical change logging.
How do I install it?
Run `npx skills add ECNU-ICALK/AutoSkill --skill postgresql-inventory-tracking-schema-design --agent claude-code` — it drops the skill into your project so the agent can pick it up. Swap the --agent value for codex, cursor or copilot if you use one of those.
Where does this skill come from?
From ECNU-ICALK/AutoSkill, a repository with 539 stars. We read it straight from the repository tree rather than a submitted listing, so what you see here is what is actually published.
Is a popular skill a good skill?
Not necessarily. Stars measure attention, not adoption — a repository can trend for a week and be abandoned. That is why we show the weekly change from our own snapshots next to the total, instead of a single flattering number.