SQL. Collections. Documents. Search. Memory. One file.
$ poop init myproject
💩 Database created: myproject.poop.db
$ poop collect insert users '{"name": "Myles", "role": "founder"}'
✓ Inserted into "users"
$ poop search "authentication flow"
3 results found
Six primitives. One database. Zero configuration.
Full relational database. Tables, joins, indexes.
Schemaless NoSQL. Just throw JSON at it.
Ingest files. FTS5 hybrid search.
Observe, compact, recall. Agents remember.
Claude Code, Cursor, Windsurf. One command.
Everything in a single .poop.db SQLite file.
Use poopabase from any language or the command line.
import { Poopabase } from "@poopabase/sdk";
const db = new Poopabase("myproject.poop.db");
// SQL
const users = await db.query("SELECT * FROM users WHERE role = ?", ["founder"]);
// Collections
await db.collection("events").insert({ type: "signup", ts: Date.now() });
// Search
const results = await db.search("authentication flow");