Assisted-by: Claude Opus 4.6 via pi

diff --git a/crates/ranger-lib/src/lib.rs b/crates/ranger-lib/src/lib.rs
index fcd7ec1..646ff77 100644
--- a/crates/ranger-lib/src/lib.rs
+++ b/crates/ranger-lib/src/lib.rs
@@ -2,4 +2,5 @@ pub mod db;
 pub mod error;
 pub mod key;
 pub mod models;
+pub mod ops;
 pub mod position;
diff --git a/crates/ranger-lib/src/ops/backlog.rs b/crates/ranger-lib/src/ops/backlog.rs
new file mode 100644
index 0000000..860d1cf
--- /dev/null
+++ b/crates/ranger-lib/src/ops/backlog.rs
@@ -0,0 +1,82 @@
+use crate::error::RangerError;
+use crate::key;
+use crate::models::Backlog;
+use sqlx::SqlitePool;
+
+pub async fn create(pool: &SqlitePool, name: &str) -> Result<Backlog, RangerError> {
+    let key = key::generate_key();
+    let backlog = sqlx::query_as::<_, Backlog>(
+        "INSERT INTO backlogs (key, name) VALUES (?, ?) RETURNING id, key, name, created_at, updated_at",
+    )
+    .bind(&key)
+    .bind(name)
+    .fetch_one(pool)
+    .await?;
+    Ok(backlog)
+}
+
+pub async fn list(pool: &SqlitePool) -> Result<Vec<Backlog>, RangerError> {
+    let backlogs = sqlx::query_as::<_, Backlog>(
+        "SELECT id, key, name, created_at, updated_at FROM backlogs ORDER BY name",
+    )
+    .fetch_all(pool)
+    .await?;
+    Ok(backlogs)
+}
+
+pub async fn get_by_key_prefix(pool: &SqlitePool, prefix: &str) -> Result<Backlog, RangerError> {
+    let pattern = format!("{prefix}%");
+    let matches = sqlx::query_as::<_, Backlog>(
+        "SELECT id, key, name, created_at, updated_at FROM backlogs WHERE key LIKE ?",
+    )
+    .bind(&pattern)
+    .fetch_all(pool)
+    .await?;
+
+    match matches.len() {
+        0 => Err(RangerError::KeyNotFound(prefix.to_string())),
+        1 => Ok(matches.into_iter().next().unwrap()),
+        _ => Err(RangerError::AmbiguousPrefix(prefix.to_string())),
+    }
+}
+
+#[cfg(test)]
+mod tests {
+    use super::*;
+    use crate::db;
+    use tempfile::tempdir;
+
+    async fn test_pool() -> SqlitePool {
+        let dir = tempdir().unwrap();
+        let dir = Box::leak(Box::new(dir));
+        db::connect(&dir.path().join("test.db")).await.unwrap()
+    }
+
+    #[tokio::test]
+    async fn create_and_get_backlog() {
+        let pool = test_pool().await;
+        let backlog = create(&pool, "My Backlog").await.unwrap();
+        assert_eq!(backlog.name, "My Backlog");
+        assert!(!backlog.key.is_empty());
+
+        let fetched = get_by_key_prefix(&pool, &backlog.key[..3]).await.unwrap();
+        assert_eq!(fetched.id, backlog.id);
+    }
+
+    #[tokio::test]
+    async fn list_backlogs() {
+        let pool = test_pool().await;
+        create(&pool, "First").await.unwrap();
+        create(&pool, "Second").await.unwrap();
+
+        let backlogs = list(&pool).await.unwrap();
+        assert_eq!(backlogs.len(), 2);
+    }
+
+    #[tokio::test]
+    async fn get_by_key_prefix_not_found() {
+        let pool = test_pool().await;
+        let result = get_by_key_prefix(&pool, "nonexistent").await;
+        assert!(result.is_err());
+    }
+}
diff --git a/crates/ranger-lib/src/ops/mod.rs b/crates/ranger-lib/src/ops/mod.rs
new file mode 100644
index 0000000..40d080e
--- /dev/null
+++ b/crates/ranger-lib/src/ops/mod.rs
@@ -0,0 +1 @@
+pub mod backlog;