# Crm Lite

> Use when tracking customer interactions, managing leads, or building a lightweight CRM for small businesses without dedicated CRM software. Stores contacts, leads, activities, estimates, and communications in local SQLite.

- **Type:** Skill
- **Install:** `agentstack add skill-hewi333-mom-n-pop-skills-crm-lite`
- **Verified:** Yes — security-reviewed for prompt injection and unsafe behavior
- **Seller:** [hewi333](https://agentstack.voostack.com/s/hewi333)
- **Installs:** 0
- **Category:** [Databases](https://agentstack.voostack.com/c/databases)
- **Latest version:** 0.1.0
- **License:** MIT
- **Upstream author:** [hewi333](https://github.com/hewi333)
- **Source:** https://github.com/hewi333/Mom-n-Pop-Skills/tree/main/skills/crm-lite

## Install

```sh
agentstack add skill-hewi333-mom-n-pop-skills-crm-lite
```

Requires the [AgentStack CLI](https://agentstack.voostack.com/docs/cli). Works with Claude Code, Cursor, and any MCP-compatible agent.

## About

# CRM-Lite — Lightweight SQLite CRM for Small Business

## Overview
A minimal, file-based CRM built on SQLite for non-technical small business owners. No server, no external dependencies, no auth complexity. Designed for agent-mediated use: the owner interacts via text message with the agent, which reads/writes this database.

## When to Use
- **Small business** (1-10 employees) with no existing CRM
- **Agent-mediated access** — owners interact via chat/Telegram, not direct DB access
- **Lead tracking** from website forms, referrals, email inquiries
- **Pipeline visibility** — estimate sent → accepted/rejected → job scheduled → paid
- **Communication log** — every email, call, text logged automatically

## Don't Use For
- Multi-user concurrent access with role-based permissions
- Complex sales methodologies (MEDDIC, Challenger, etc.)
- Real-time collaboration features
- Integration with enterprise SSO/SCIM

## Core Features

### Data Model (SQLite: `crm.db`)
1. **customers** — Core customer records
   - `id` (PK), `name`, `email`, `phone`, `company`, `address`, `city`, `state`, `zip`
   - `lead_source`, `lead_status` (new/qualified/estimate_sent/won/lost)
   - `total_value`, `notes`, `created_at`, `updated_at`

2. **leads** — Inbound leads before qualification
   - `id`, `source` (website/referral/email/phone), `contact_name`
   - `contact_email`, `contact_phone`, `company`, `property_address`
   - `sqft`, `ceiling_height`, `service_type`, `urgency`
   - `status` (new/qualified/estimate_ready/scheduled/lost)
   - `assigned_to`, `created_at`, `updated_at`

3. **activities** — Every touchpoint
   - `id`, `customer_id` (FK), `lead_id` (FK), `activity_type` (call/email/text/meeting/estimate_sent/estimate_accepted/estimate_rejected/job_scheduled/job_completed/invoice_sent/payment_received)
   - `description`, `outcome`, `next_action`, `next_action_date`
   - `created_at`, `updated_at`

4. **estimates** — Estimate lifecycle
   - `id`, `customer_id`, `lead_id`, `estimate_number`, `amount`
   - `status` (draft/sent/accepted/rejected/expired)
   - `sent_date`, `accepted_date`, `rejected_date`, `expires_date`
   - `line_items` (JSON), `notes`, `created_at`, `updated_at`

5. **communications** — Message log
   - `id`, `customer_id`, `lead_id`, `direction` (inbound/outbound)
   - `channel` (email/sms/telegram/phone), `subject`, `body`
   - `sent_at`, `created_at`

6. **tasks** — Action items for owners
   - `id`, `customer_id`, `lead_id`, `title`, `description`
   - `due_date`, `priority` (low/medium/high/urgent), `status` (pending/in_progress/done)
   - `assigned_to`, `created_at`, `updated_at`

## Quick Start

```python
import sqlite3
from pathlib import Path

DB_PATH = Path("~/.hermes/crm/crm.db").expanduser()
DB_PATH.parent.mkdir(parents=True, exist_ok=True)

def init_db():
    conn = sqlite3.connect(DB_PATH)
    conn.execute("""
        CREATE TABLE IF NOT EXISTS customers (
            id INTEGER PRIMARY KEY AUTOINCREMENT,
            name TEXT NOT NULL, email TEXT, phone TEXT,
            company TEXT, address TEXT, city TEXT, state TEXT, zip TEXT,
            lead_source TEXT, lead_status TEXT DEFAULT 'new',
            total_value REAL DEFAULT 0, notes TEXT,
            created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
            updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
        )
    """)
    # ... other tables
    conn.commit()
    return conn
```

## Agent Integration Patterns

### Create Lead from Website Form
```
User: "New lead from website: John Smith, john@email.com, 555-555-0123, 123 Main St [CITY] [STATE] [ZIP], 2500 sqft, service request"
Agent: Creates lead record, sets status=qualified, creates task for the owner to review
```

### Log Estimate Sent
```
User: "Sent estimate #EST-0001-0042 to John Smith for $2,850"
Agent: Updates estimate status=sent, creates activity, creates task for follow-up in 3 days
```

### Weekly Pipeline Report (Cron)
```
Agent: Queries all leads/customers, summarizes by stage, sends to the owner via Telegram
```

## End-to-End Demo Flow

This skill is the central hub for the demo flow. The full orchestration across all 7 skills is documented in `references/demo-flow.md` — read it before building or recording the demo. It covers: lead intake -> estimate -> Stripe payment link -> email -> payment confirmation -> calendar scheduling -> daily report, plus the 90-second demo script and credential checklist.

## Common Pitfalls

1. **Forgetting to create indexes** — Add indexes on `customers.email`, `leads.status`, `activities.customer_id` for query speed
2. **Not backing up** — SQLite file is the entire DB; copy to S3/Drive daily via cron
3. **Schema drift** — Use migrations (numbered SQL files) rather than ad-hoc ALTER TABLE
4. **Concurrent writes** — SQLite handles concurrent reads, but writes serialize; keep transactions short

## Verification Checklist

- [ ] `crm.db` created with all 6 tables
- [ ] Indexes on foreign keys and query columns
- [ ] Agent can: create lead, log activity, update estimate status, create task
- [ ] Weekly report cron outputs: new leads, estimates sent, conversion rate, pipeline value
- [ ] Backup script copies DB to offsite location daily

## One-Shot Recipes

### "New lead from referral"
```python
conn = init_db()
lead_id = conn.execute("""
    INSERT INTO leads (source, contact_name, contact_email, contact_phone, company, property_address, sqft, service_type, status)
    VALUES ('referral', 'Jane Doe', 'jane@example.com', '555-555-0199', 'Example Realty', '456 Palm Ave [CITY] [STATE] [ZIP]', 3200, 'service_request', 'qualified')
""").lastrowid
conn.commit()
```

### "Get pipeline summary for weekly report"
```python
summary = conn.execute("""
    SELECT
        COUNT(CASE WHEN lead_status='new' THEN 1 END) as new_leads,
        COUNT(CASE WHEN lead_status='estimate_sent' THEN 1 END) as estimates_out,
        COUNT(CASE WHEN lead_status='won' THEN 1 END) as won,
        SUM(CASE WHEN lead_status='won' THEN total_value ELSE 0 END) as revenue
    FROM customers
""").fetchone()
```

## Source & license

This open-source skill is cataloged on AgentStack and links to its original source — we do not rehost the code.

- **Author:** [hewi333](https://github.com/hewi333)
- **Source:** [hewi333/Mom-n-Pop-Skills](https://github.com/hewi333/Mom-n-Pop-Skills)
- **License:** MIT

Install and usage instructions live in the source repository linked above.

## Pricing

- **Free** — Free

## Security capabilities

Automated source analysis of v0.1.0 — what this tool can access:

- **Network access:** no
- **Filesystem access:** yes
- **Shell / process execution:** no
- **Environment & secrets:** no
- **Dynamic code execution:** no

*"Yes" means the capability is present in the source — more access means more to trust, not that it is unsafe.*


## Versions

- **0.1.0** — security scan: passed — Imported from the upstream source.

## Links

- Listing page: https://agentstack.voostack.com/l/skill-hewi333-mom-n-pop-skills-crm-lite
- Seller: https://agentstack.voostack.com/s/hewi333
- Browse the marketplace: https://agentstack.voostack.com/browse

---
Listed on AgentStack — the marketplace for AI agent skills and MCP servers. Every listing is security-reviewed. Creators keep 70%.