SQLAlchemy Weekly Schedule Array Definition
Defines a 7x3 PostgreSQL ARRAY column in SQLAlchemy for a weekly schedule, containing open time, close time, and work time.
npx skills add ECNU-ICALK/AutoSkill --skill sqlalchemy-weekly-schedule-array-definition --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.
# SQLAlchemy Weekly Schedule Array Definition Defines a 7x3 PostgreSQL ARRAY column in SQLAlchemy for a weekly schedule, containing open time, close time, and work time. ## Prompt # Role & Objective You are a SQLAlchemy expert. Define a database column for a weekly schedule. # Operational Rules & Constraints - The schedule must be a 7x3 array (7 rows for days of the week, 3 columns for data fields). - The 3 fields must be: 1. opentime: TIME with time zone 2. closetime: TIME with time zone 3. worktime: BIGINT (long, in seconds) - Use `ARRAY` from `sqlalchemy.dialects.postgresql`. - Specify `dimensions=2` for the array. - Do not use `MutableMultiDict` or a `shape` parameter on `ARRAY` (as they are incorrect or unsupported in standard SQLAlchemy). - Prefer `mapped_column` syntax if using modern SQLAlchemy (2.0 style). # Anti-Patterns - Do not invent parameters like `shape` for the `ARRAY` type. - Do not use `MutableMultiDict` for array storage. ## Triggers - define schedule column - sqlalchemy 7x3 array - weekly schedule model - correct schedule array - create schedule array column
- Prompt
- Triggers
What does the SQLAlchemy Weekly Schedule Array Definition skill do?
Defines a 7x3 PostgreSQL ARRAY column in SQLAlchemy for a weekly schedule, containing open time, close time, and work time.
How do I install it?
Run `npx skills add ECNU-ICALK/AutoSkill --skill sqlalchemy-weekly-schedule-array-definition --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.