Legal Casefile SQLite Tools

This repository contains extensions to the SQLite MCP server for managing legal case files and billing processes.

Features

• Database validation and health check
• Schema management for case file and billing data
• Tools for loading Excel/CSV data into SQLite database
• Integration with Claude for efficient case file management

Tool Overview

validate_database

Performs database validation and health checks.

load_excel_to_sqlite

Loads and normalizes data from Excel spreadsheets into the SQLite database.

casefile_to_billing

Processes case file data to generate billing records.

Schema

The database schema follows the case file structure with these primary tables:

• case_file_records: Stores the main case file entries
• billing_records: Stores the billing-specific information

Each record maintains the structure described in the case file schema with appropriate columns for:

• Type information
• Date and time data
• Content and relational data
• Billing-specific fields

Installation and Configuration

Instructions for setting up and configuring the extended SQLite MCP server.

Usage Examples

Code examples for interacting with the database and using the tools.