How to build a home inventory with Claude

Set up a home inventory for me in databasedmcp, in one go.

1. Create a database called home, described as "Home inventory: places, the items kept in them, what they cost and their warranties".
2. Create two tables:
   - places: id, name (required: a cupboard, shelf or box), room (required: the room the place is in, so "Box 3" can be in "Attic").
   - items: id, name (required), place_id (references places), category, quantity (defaults to 1), price (whole euros, per item), bought_on (date), warranty_until (date, or NULL if there's none), notes (model numbers and anything else worth knowing), updated_at (defaults to now).
3. Write the database a guide that says what each table is for: one item row per kind of thing, with a quantity. It should say to check a place or item doesn't already exist before adding it, and that when something moves, you update its place_id instead of adding a second row. Include the queries for "where is it": items matching a name, with their place and room, and "value by room": price times quantity added up per room, highest first.

From then on: when I tell you what's in a place, add the place if it's new and the items in it. When I move something, update where it is and its updated_at. Show me the tables when you're finished.

CREATE TABLE places (
  id INTEGER PRIMARY KEY,
  name TEXT NOT NULL,
  room TEXT NOT NULL
);

CREATE TABLE items (
  id INTEGER PRIMARY KEY,
  name TEXT NOT NULL,
  place_id INTEGER REFERENCES places(id),
  category TEXT,
  quantity INTEGER NOT NULL DEFAULT 1,
  price INTEGER,
  bought_on TEXT,
  warranty_until TEXT,
  notes TEXT,
  updated_at TEXT NOT NULL DEFAULT CURRENT_TIMESTAMP
);

# home: what we own and where it is

- **places**: rooms, cupboards, shelves, boxes. `room` is the room a place is in, so "Box 3" can live in "Attic".
- **items**: one row per kind of thing, with `quantity`. `price` is what it cost per item, in whole euros. `warranty_until` is a date or NULL. `notes` holds model numbers and anything else worth knowing.

Before adding a place or item, check it doesn't exist. When something moves, update `place_id`; don't add a second row.

Where is it: `SELECT i.name, p.name AS place, p.room FROM items i JOIN places p ON p.id = i.place_id WHERE i.name LIKE ?`

Value by room: `SELECT p.room, sum(i.price * i.quantity) AS value FROM items i JOIN places p ON p.id = i.place_id GROUP BY p.room ORDER BY value DESC`

INSERT INTO places (name, room) SELECT json_extract(value, '$.name'), json_extract(value, '$.room') FROM json_each(?)
-- params: ["[{\"name\":\"Tall cupboard\",\"room\":\"Garage\"},{\"name\":\"Shelf above washer\",\"room\":\"Utility room\"},{\"name\":\"Blue box\",\"room\":\"Attic\"}]"]

INSERT INTO items (name, place_id, category, quantity, price, bought_on, warranty_until) SELECT json_extract(value, '$.name'), ?, json_extract(value, '$.category'), json_extract(value, '$.qty'), json_extract(value, '$.price'), json_extract(value, '$.bought'), json_extract(value, '$.warranty') FROM json_each(?)
-- params: [1,"[{\"name\":\"Cordless drill\",\"category\":\"tools\",\"qty\":1,\"price\":129,\"bought\":\"2026-03-14\",\"warranty\":\"2028-03-14\"},{\"name\":\"Tent pegs\",\"category\":\"camping\",\"qty\":40,\"price\":null,\"bought\":null,\"warranty\":null}]"]

INSERT INTO items (name, place_id, category, quantity, price) VALUES (?, ?, ?, ?, ?)
-- params: ["Winter duvet",3,"bedding",2,80]

UPDATE items SET place_id = ?, updated_at = datetime('now') WHERE name LIKE ?
-- params: [2,"%drill%"]

SELECT i.name, p.name AS place, p.room, i.updated_at FROM items i JOIN places p ON p.id = i.place_id WHERE i.name LIKE ?
-- params: ["%drill%"]

SELECT p.room, count(*) AS items, sum(i.price * i.quantity) AS value_eur FROM items i JOIN places p ON p.id = i.place_id WHERE i.price IS NOT NULL GROUP BY p.room ORDER BY value_eur DESC

SELECT name, bought_on, warranty_until FROM items WHERE warranty_until BETWEEN date('now') AND date('now', '+6 months') ORDER BY warranty_until