init-db

Initialize an SQLite artifact store with FTS5 and required directories.

1|1|Updated Mar 9, 2026
One-click install
npx skills add https://github.com/trevorbyrum/claude-skills-suite --skill init-db
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: init-db
Source: https://github.com/trevorbyrum/claude-skills-suite/tree/main/skills/init-db
Command: npx skills add https://github.com/trevorbyrum/claude-skills-suite --skill init-db

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

This Skill sets up the essential artifact storage for a project, ensuring that all necessary directories and the project database are created and ready for use.

Core Features & Use Cases

  • Artifact Directory Creation: Automatically creates artifacts/ and its subdirectories (research/summary, reviews).
  • Database Initialization: Sets up artifacts/project.db using SQLite with FTS5 for efficient searching.
  • Idempotent Operation: Safe to re-run without unintended side effects, ensuring the database schema is created only if it doesn't exist.
  • Use Case: When starting a new project, run this Skill to prepare the foundational structure for storing research, summaries, reviews, and the project's core database.

Quick Start

Run the init-db skill to set up the project's artifact store and database.

Frequently Asked Questions about init-db

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I set up an SQLite database for a new project?

To set up an SQLite database for a new project, run this Skill to create a project.db file with FTS5 search capabilities, automatically generating the necessary directory structure for managing artifacts.

What is the best way to initialize a project artifact store?

The best way to initialize a project artifact store is to run this Skill, which creates dedicated research and review directories alongside a searchable SQLite database to hold all foundational project artifacts.

Does database initialization work in non-Git repository contexts?

Database initialization works in both Git and non-Git repository contexts, detecting the environment during setup to ensure the SQLite database and artifact directories are created correctly regardless of version control.

Can I safely re-run database setup without corrupting existing artifacts?

You can safely re-run database setup because the operation is idempotent, ensuring the SQLite schema is only created if it does not exist and preventing unintended side effects or data corruption in existing artifacts.

How does FTS5 improve SQLite artifact management?

FTS5 improves SQLite artifact management by enabling full-text search capabilities within the project database, allowing users to efficiently query and retrieve stored research summaries and reviews.

What directories are created when bootstrapping a project database?

Bootstrapping a project database creates an artifacts directory containing research summary and reviews subdirectories, providing a structured file system to organize and store project outputs.