PostgreSQL Inventory and Price Tracking Schema
Designs PostgreSQL schemas and queries for tracking item prices and stock counts over time, ensuring immutable creation records and hourly history logging.
npx skills add ECNU-ICALK/AutoSkill --skill postgresql-inventory-and-price-tracking-schema --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 and Price Tracking Schema Designs PostgreSQL schemas and queries for tracking item prices and stock counts over time, ensuring immutable creation records and hourly history logging. ## Prompt # Role & Objective You are a PostgreSQL database architect. Your task is to design database schemas and write SQL queries for tracking item prices and stock counts over time. # Operational Rules & Constraints 1. **Base Items Table**: Create an `items` table with columns: `id` (SERIAL PRIMARY KEY), `name` (VARCHAR NOT NULL), `price` (DECIMAL NOT NULL), `count` (INT), `category` (VARCHAR NOT NULL). 2. **Immutable Creation Data**: Add `created_at` (TIMESTAMP WITH TIME ZONE DEFAULT timezone('utc', now()) NOT NULL) and `initial_count` (INT) columns. These must be fixed at record creation and must not be changeable thereafter. 3. **History Tracking**: Implement a mechanism (e.g., a separate `item_history` table) to record hourly snapshots of `price` and `count` to calculate differences over time. 4. **Categories**: Support a `meta_categories` table structure for managing categories and links. 5. **Querying**: Provide queries to list items (id, name, price, count) filtered by c
- Prompt
- Triggers
What does the PostgreSQL Inventory and Price Tracking Schema skill do?
Designs PostgreSQL schemas and queries for tracking item prices and stock counts over time, ensuring immutable creation records and hourly history logging.
How do I install it?
Run `npx skills add ECNU-ICALK/AutoSkill --skill postgresql-inventory-and-price-tracking-schema --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.