MCP Law Office Db

🚀 Law Office SQLite MCP Server

A Model Context Protocol (MCP) server implementation designed specifically for law firms, used for client record management, case file tracking, time recording, and invoice generation.

🚀 Quick Start

This server offers a specialized database interface for law firms, enabling them to:

• Manage client and matter records.
• Track case file entries (documents, communications, notes).
• Record billable time and associate it with specific case activities.
• Create and validate client invoices.
• Enforce business rules to ensure compliant billing.

✨ Features

Core Database Operations

• Standard SQL operations (SELECT, INSERT, UPDATE, DELETE).
• Table management and schema information query.
• Support for multi - statement transactions and batch operations through the execute_script tool.

Professional Legal Tools

• record_case_entry: Add documents to the case file.
• record_billable_time: Record billable time with sufficient evidence.
• get_unbilled_time: Track unbilled workload by client or matter.
• create_invoice: Generate new client invoices.
• add_billing_to_invoice: Associate time records with specific invoices.
• check_invoice_validity: Verify if there are billing conflicts in the invoice.
• submit_invoice: Finalize and submit the invoice to the client.

Database Schema

• Client and matter management tables.
• Case file document management system.
• Comprehensive billing and invoicing workflows.
• Automated timestamp management.
• Conflict detection to avoid duplicate or overlapping time records.

📦 Installation

Dependencies

• Python 3.10 or higher (Python 3.11 is recommended). Check the version using python3.11 --version (or similar commands). If installation is required, use the system package manager (e.g., brew install python@3.11 on macOS/Linux).
• uv: A fast Python package installation tool. Install it from astral.sh (curl -LsSf https://astral.sh/uv/install.sh | sh).
• SQLite3 (usually pre - installed on macOS/Linux).
• Git (for cloning the repository).

Installation Steps

1. Clone the repository:

git clone <repository_url> # Replace with your repository URL
cd mcp-law-office-db # Or your repository directory name

2. Create and activate a virtual environment (using your Python 3.10+ interpreter):

# Replace python3.11 with the specific version you are using (e.g., python3.10)
python3.11 -m venv .venv
source .venv/bin/activate

(The terminal prompt should display (.venv))

3. Install dependencies:

pip install -r requirements.txt # Assuming the project contains a requirements file

4. Configure the database:

cp config.example.json config.json # Modify the configuration file as needed

5. Start the server:

python app.py # Start the MCP service

💻 Usage Examples

Basic Usage

Connect to the database:

import sqlite3
conn = sqlite3.connect('law_office.db')

Create a matter record:

cursor = conn.cursor()
cursor.execute("INSERT INTO matters (client_id, matter_title) VALUES (?, ?)", ("CLIENT_001", "Contract Review"))
conn.commit()

Query case files:

cursor.execute("SELECT * FROM case_files WHERE matter_id = ?", ("MATTER_001",))
files = cursor.fetchall()
print(files)

Advanced Usage

Batch processing:

./execute_script.sh "UPDATE clients SET status = 'active' WHERE region = 'east'"

Time recording:

from mcp_server import record_time
record_time("CLIENT_001", "MATTER_001", 2.5, "Contract Review Meeting")

📚 Documentation

Online Documentation

Visit Law Office MCP Server Documentation for more detailed information.

Support

If you need help or want to report an issue, please contact support@lawofficemcps.com.

This project aims to provide an efficient and secure database solution for law firms, simplifying daily operations and improving efficiency.