Legal Casefile SQLite Tools
Extended SQLite MCP server tools for legal case file management and billing
asirulnik
README
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 entriesbilling_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.
Recommended Servers
playwright-mcp
A Model Context Protocol server that enables LLMs to interact with web pages through structured accessibility snapshots without requiring vision models or screenshots.
Magic Component Platform (MCP)
An AI-powered tool that generates modern UI components from natural language descriptions, integrating with popular IDEs to streamline UI development workflow.
MCP Package Docs Server
Facilitates LLMs to efficiently access and fetch structured documentation for packages in Go, Python, and NPM, enhancing software development with multi-language support and performance optimization.
Claude Code MCP
An implementation of Claude Code as a Model Context Protocol server that enables using Claude's software engineering capabilities (code generation, editing, reviewing, and file operations) through the standardized MCP interface.
@kazuph/mcp-taskmanager
Model Context Protocol server for Task Management. This allows Claude Desktop (or any MCP client) to manage and execute tasks in a queue-based system.
Linear MCP Server
Enables interaction with Linear's API for managing issues, teams, and projects programmatically through the Model Context Protocol.
mermaid-mcp-server
A Model Context Protocol (MCP) server that converts Mermaid diagrams to PNG images.
Jira-Context-MCP
MCP server to provide Jira Tickets information to AI coding agents like Cursor
Linear MCP Server
A Model Context Protocol server that integrates with Linear's issue tracking system, allowing LLMs to create, update, search, and comment on Linear issues through natural language interactions.
Sequential Thinking MCP Server
This server facilitates structured problem-solving by breaking down complex issues into sequential steps, supporting revisions, and enabling multiple solution paths through full MCP integration.