{"id":46580,"library":"tasks-sqlite","title":"tasks-sqlite","description":"A streaming AI agent for project and task management, powered by Mimic synthetic data and the Vercel AI SDK, using SQLite as a file-based database without Docker or external databases. Version 1.0.4 is the current stable release. Key differentiators: no Docker required, file-based SQLite, streaming responses via AI SDK Message Stream protocol, synthetic data generation with Mimic, and a minimal Next.js chat UI. Designed for local development and testing, with a quick setup and multi-turn conversation support.","status":"active","version":"1.0.4","language":"javascript","source_language":"en","source_url":null,"tags":["javascript"],"install":[{"cmd":"npm install tasks-sqlite","lang":"bash","label":"npm"},{"cmd":"yarn add tasks-sqlite","lang":"bash","label":"yarn"},{"cmd":"pnpm add tasks-sqlite","lang":"bash","label":"pnpm"}],"dependencies":[{"reason":"Used for generating synthetic data and seeding the database.","package":"@mimicai/cli","optional":false},{"reason":"SQLite driver for Node.js to interact with the database.","package":"better-sqlite3","optional":false},{"reason":"Vercel AI SDK for streaming responses and model integration.","package":"ai","optional":false},{"reason":"Provides the useChat hook for the Next.js UI.","package":"@ai-sdk/react","optional":true},{"reason":"Framework for the chat UI.","package":"next","optional":true}],"imports":[{"note":"In newer versions of Vercel AI SDK, useChat moved from 'ai/react' to '@ai-sdk/react'. Using the old path will fail.","wrong":"import { useChat } from 'ai/react'","symbol":"useChat","correct":"import { useChat } from '@ai-sdk/react'"},{"note":"streamText is a named export, not a default export.","wrong":"import { StreamText } from 'ai'","symbol":"streamText","correct":"import { streamText } from 'ai'"},{"note":"better-sqlite3 exports a default function, not a named export. Use default import.","wrong":"const { Database } = require('better-sqlite3')","symbol":"Database (better-sqlite3)","correct":"import Database from 'better-sqlite3'"}],"quickstart":{"code":"// Step 1: Install dependencies (run in project root)\nnpm install\n\n// Step 2: Create and seed the database\n// Run ./init-db.sh (creates tasks.db)\n// Then: npx mimic run && npx mimic seed --verbose\n\n// Step 3: Set environment variables\n// Create .env file: ANTHROPIC_API_KEY=sk-ant-...\n// Then: export $(cat .env | xargs)\n\n// Step 4: Start the agent\ncd agent\nnpm install\nnpm start\n\n// Step 5: Test with curl\ncurl -X POST http://localhost:3002/chat \\\n  -H \"Content-Type: application/json\" \\\n  -d '{\"messages\": [{\"role\": \"user\", \"content\": \"What projects are active?\"}]}'","lang":"javascript","description":"Complete setup to install dependencies, create database, generate synthetic data, start agent, and test with curl."},"warnings":[{"fix":"Upgrade Node.js to version 22 or later.","message":"Requires Node.js >= 22. Older versions will fail to run the agent.","severity":"breaking","affected_versions":">=1.0.0"},{"fix":"Use import { useChat } from '@ai-sdk/react' instead of 'ai/react'.","message":"The useChat hook import path changed in AI SDK v3 from 'ai/react' to '@ai-sdk/react'.","severity":"deprecated","affected_versions":">=3.0.0"},{"fix":"Ensure you are in the project root when running ./init-db.sh.","message":"The init-db.sh script must be run from the root directory. Running from a different directory will fail to create the database correctly.","severity":"gotcha","affected_versions":">=1.0.0"},{"fix":"Set ANTHROPIC_API_KEY environment variable with a valid Anthropic API key.","message":"The agent requires an Anthropic API key. Using a different LLM provider (e.g., OpenAI) is not supported out-of-the-box.","severity":"gotcha","affected_versions":">=1.0.0"},{"fix":"Keep both the agent (npm start in agent/) and the UI (npm run dev in ui/) running simultaneously.","message":"The UI and agent run on separate ports (3000 and 3002). Starting only one will result in connection errors.","severity":"gotcha","affected_versions":">=1.0.0"}],"env_vars":null,"search_vec":"'1.0.4':37 'agent':7 'ai':6,21,55 'base':29,50 'chat':69 'convers':85 'current':40 'data':17,61 'databas':30,35 'design':71 'develop':74 'differenti':44 'docker':32,46 'extern':34 'file':28,49 'file-bas':27,48 'generat':62 'javascript':87 'key':43 'local':73 'manag':12 'messag':57 'mimic':15,64 'minim':67 'multi':83 'multi-turn':82 'next.js':68 'power':13 'project':9 'protocol':59 'quick':79 'releas':42 'requir':47 'respons':53 'sdk':22,56 'setup':80 'sqlite':3,24,51 'stabl':41 'stream':5,52,58 'support':86 'synthet':16,60 'task':2,11 'tasks-sqlit':1 'test':76 'turn':84 'ui':70 'use':23 'vercel':20 'version':36 'via':54 'without':31","created_at":"2026-06-07T13:00:37.035842+00:00","updated_at":"2026-06-07T13:00:37.035842+00:00","problems":[{"fix":"Run npm install in both the agent/ and ui/ directories.","cause":"The ai package is not installed in the agent or UI directory.","error":"Error: Cannot find module 'ai'"},{"fix":"Install sqlite3: on macOS it's pre-installed; on Debian/Ubuntu run 'apt install sqlite3'.","cause":"The sqlite3 CLI is not installed on the system.","error":"sqlite3: command not found"},{"fix":"Upgrade Node.js to version 22 or later.","cause":"Running with Node.js version older than 22 which does not support newer JavaScript syntax.","error":"Error: Unexpected token '.'"},{"fix":"Change import to: import { useChat } from '@ai-sdk/react'.","cause":"Importing useChat from 'ai/react' instead of '@ai-sdk/react' in newer AI SDK versions.","error":"TypeError: (0 , ai_react.useChat) is not a function"}],"ecosystem":"npm","meta_description":null,"install_score":null,"quickstart_score":null,"quickstart_tag":null,"pypi_latest":null,"cli_name":null,"cli_version":null,"type":"library","homepage":null,"github":null,"docs":null,"changelog":null,"pypi":null,"npm":"tasks-sqlite","openapi_spec":null,"status_page":null,"smithery":null,"categories":["productivity"],"base_url":null,"auth_type":null,"provenance":{"verified_status":null,"verified_at":null,"last_verified":"2026-06-07","next_check":"2026-09-05","install_tag":null}}