Alternative to Trello: a personal kanban board with Claude

Set up a personal kanban board for me in databasedmcp, in one go.

1. Create a database called kanban, described as "My kanban boards: boards, lists and cards, moved by Claude when I say what I'm working on".
2. Create three tables:
   - boards: id, name (required, unique), archived_at (NULL while the board is in use).
   - lists: id, board_id (references boards), name (required, such as To do, Doing, Done), position (number, left to right).
   - cards: id, list_id (references lists), title (required), description, position (number, top to bottom), due (date, optional), created_at and moved_at (both default to now).
3. Write the database a guide that says what each table is for, that a new board gets the lists To do, Doing and Done unless I ask for others, that moving a card means changing its list_id and setting moved_at, that a new card goes to the bottom of its list, and the queries for "show me the board", "what's been stuck in Doing for two weeks" and "what got done this month".

From then on: when I mention something for a project, add a card to its board. When I say I've started or finished something, move the card. When I ask to see a board, list its cards by list and position. Show me the tables when you're finished.

CREATE TABLE boards (
  id INTEGER PRIMARY KEY,
  name TEXT NOT NULL UNIQUE,
  archived_at TEXT
);

CREATE TABLE lists (
  id INTEGER PRIMARY KEY,
  board_id INTEGER NOT NULL REFERENCES boards(id),
  name TEXT NOT NULL,
  position INTEGER NOT NULL
);

CREATE TABLE cards (
  id INTEGER PRIMARY KEY,
  list_id INTEGER NOT NULL REFERENCES lists(id),
  title TEXT NOT NULL,
  description TEXT,
  position INTEGER NOT NULL,
  due TEXT,
  created_at TEXT NOT NULL DEFAULT CURRENT_TIMESTAMP,
  moved_at TEXT NOT NULL DEFAULT CURRENT_TIMESTAMP
);

# kanban: my boards

- **boards**: one per project. Look one up by name before adding. A new board gets the lists To do, Doing, Done.
- **lists**: columns on a board, left to right by `position`.
- **cards**: one per piece of work. A new card goes to the bottom of its list (max position + 1). To move a card, set `list_id` and `moved_at`.

The board: `SELECT l.name AS list, c.id, c.title, c.due FROM lists l LEFT JOIN cards c ON c.list_id = l.id WHERE l.board_id = 1 ORDER BY l.position, c.position`

Stuck in Doing: `SELECT c.title, c.moved_at FROM cards c JOIN lists l ON l.id = c.list_id WHERE l.name = 'Doing' AND c.moved_at < datetime('now', '-14 days')`

INSERT INTO boards (name) VALUES (?) RETURNING id
-- params: ["Kitchen renovation"]

INSERT INTO lists (board_id, name, position) VALUES (?, ?, 1), (?, ?, 2), (?, ?, 3)
-- params: [1,"To do",1,"Doing",1,"Done"]

INSERT INTO cards (list_id, title, position, due) VALUES (?, ?, (SELECT coalesce(max(position), 0) + 1 FROM cards WHERE list_id = ?), date('now', 'start of month', '+1 month', '-1 day'))
-- params: [1,"Pick the wall tiles",1]

INSERT INTO cards (list_id, title, description, position) VALUES (?, ?, ?, (SELECT coalesce(max(position), 0) + 1 FROM cards WHERE list_id = ?))
-- params: [1,"Get three worktop quotes","Has to be oak.",1]

UPDATE cards SET list_id = (SELECT id FROM lists WHERE board_id = ? AND name = ?), moved_at = datetime('now') WHERE id = ?
-- params: [1,"Doing",1]

SELECT l.name AS list, c.id, c.title, c.due FROM lists l LEFT JOIN cards c ON c.list_id = l.id WHERE l.board_id = ? ORDER BY l.position, c.position
-- params: [1]

SELECT b.name AS board, c.title, c.moved_at FROM cards c JOIN lists l ON l.id = c.list_id JOIN boards b ON b.id = l.board_id WHERE l.name = ? AND c.moved_at < datetime('now', '-14 days') ORDER BY c.moved_at
-- params: ["Doing"]

SELECT b.name AS board, count(*) AS done FROM cards c JOIN lists l ON l.id = c.list_id JOIN boards b ON b.id = l.board_id WHERE l.name = ? AND c.moved_at >= date('now', 'start of month') GROUP BY b.id ORDER BY done DESC
-- params: ["Done"]