Alternative to Evernote: a notes archive with Claude

Set up a notes archive for me in databasedmcp, in one go.

1. Create a database called archive, described as "My notes archive: notebooks, notes and tags, kept by Claude from what I tell it".
2. Create four tables:
   - notebooks: id, name (required, unique).
   - notes: id, notebook_id (references notebooks), title (required), body (required, the text of the note), source_url (where it came from, if anywhere), created_at and updated_at (both default to now).
   - tags: id, name (required, unique, lowercase).
   - note_tags: note_id (references notes), tag_id (references tags), one row per pair.
3. Write the database a guide that says what each table is for, to look notebooks and tags up by name before adding them, to set updated_at whenever a note changes, and the queries for "search my notes for a word" and "notes with a tag".

From then on: when I ask you to save something, write it as a note in the notebook that fits, with a short title and a few tags. When I add to a note, append to its body. When I ask for something I saved, search titles and bodies. Show me the tables when you're finished.

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

CREATE TABLE notes (
  id INTEGER PRIMARY KEY,
  notebook_id INTEGER REFERENCES notebooks(id),
  title TEXT NOT NULL,
  body TEXT NOT NULL,
  source_url TEXT,
  created_at TEXT NOT NULL DEFAULT CURRENT_TIMESTAMP,
  updated_at TEXT NOT NULL DEFAULT CURRENT_TIMESTAMP
);

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

CREATE TABLE note_tags (
  note_id INTEGER NOT NULL REFERENCES notes(id),
  tag_id INTEGER NOT NULL REFERENCES tags(id),
  PRIMARY KEY (note_id, tag_id)
);

# archive: my notes

- **notebooks**: Home, Work, Recipes and so on. Look one up by name before adding.
- **notes**: one row per note. `body` is the text; `source_url` is where it came from, if anywhere. Set `updated_at` whenever a note changes. To add to a note, append to its body.
- **tags**: lowercase words. Look one up before adding (`INSERT ... ON CONFLICT(name) DO NOTHING`).
- **note_tags**: which tags each note has.

Search: `SELECT id, title, updated_at FROM notes WHERE title LIKE '%word%' OR body LIKE '%word%' ORDER BY updated_at DESC`

By tag: `SELECT n.id, n.title FROM notes n JOIN note_tags nt ON nt.note_id = n.id JOIN tags t ON t.id = nt.tag_id WHERE t.name = 'house' ORDER BY n.updated_at DESC`

INSERT INTO notebooks (name) VALUES (?) RETURNING id
-- params: ["Home"]

INSERT INTO notes (notebook_id, title, body) VALUES (?, ?, ?) RETURNING id
-- params: [1,"Boiler service","Serviced by Kettle & Pipe. Pressure should sit at 1.2 bar. Next service due next autumn."]

INSERT INTO tags (name) VALUES (?) ON CONFLICT(name) DO NOTHING
-- params: ["house"]

INSERT INTO note_tags (note_id, tag_id) SELECT ?, id FROM tags WHERE name = ?
-- params: [1,"house"]

UPDATE notes SET body = body || char(10) || ?, updated_at = datetime('now') WHERE id = ?
-- params: ["The expansion vessel will need replacing in a year or two.",1]

SELECT id, title, body, updated_at FROM notes WHERE title LIKE ? OR body LIKE ? ORDER BY updated_at DESC
-- params: ["%pressure%","%pressure%"]

SELECT n.id, n.title, n.updated_at FROM notes n JOIN note_tags nt ON nt.note_id = n.id JOIN tags t ON t.id = nt.tag_id WHERE t.name = ? ORDER BY n.updated_at DESC
-- params: ["house"]

SELECT b.name, count(n.id) AS notes, max(n.updated_at) AS last_changed FROM notebooks b LEFT JOIN notes n ON n.notebook_id = b.id GROUP BY b.id ORDER BY notes DESC