Loading skill
Install any skill in seconds. Free to start, no credit card required.
Get Started Free →moizibnyousaf/database-design
Database schema design, optimization, and migration patterns for PostgreSQL, MySQL, and NoSQL databases.
Passed 23 of 25 test cases with the skill, and 22 of 25 without it.
1 fixed22 passed either way2 still failing0 broke
Tokens, turns and time describe resource use, not a dollar price.
A test case the skill fixed. Same model, same prompt, with and without the skill.
Write a SQL query that retrieves orders for users who logged in during the past 30 days, using a CTE structure to encapsulate the active user filter.
| Checked | Without skill | With skill |
|---|---|---|
| Uses a WITH clause to define the CTE | Passed | Passed |
| Filters activity using INTERVAL '30 days' | Missed | Passed |
The instructions your model reads when the skill loads.
-- 1NF: Atomic values, no repeating groups
-- 2NF: No partial dependencies on composite keys
-- 3NF: No transitive dependencies
-- Users table (normalized)
CREATE TABLE users (
id SERIAL PRIMARY KEY,
email VARCHAR(255) UNIQUE NOT NULL,
created_at TIMESTAMPTZ DEFAULT NOW()
);
-- Addresses table (separate entity)
CREATE TABLE addresses (
id SERIAL PRIMARY KEY,
user_id INTEGER REFERENCES users(id) ON DELETE CASCADE,
street VARCHAR(255),
city VARCHAR(100),
country VARCHAR(100),
is_primary BOOLEAN DEFAULT false
);
-- When read performance matters more than write consistency
CREATE TABLE order_summaries (
id SERIAL PRIMARY KEY,
order_id INTEGER REFERENCES orders(id),
customer_name VARCHAR(255), -- Denormalized from customers
total_amount DECIMAL(10,2),
item_count INTEGER,
last_updated TIMESTAMPTZ DEFAULT NOW()
);
test cases passed, vs 22 / 25 without
Published skills whose descriptions closely match this one, with their headline benchmark lift.
More skills from the same source and nearby in the registry, with their headline benchmark lift.