clean-legal-db

Query a local SQLite legal database for statutes, regulations, and precedents.

52|12|Updated May 17, 2026
One-click install
npx skills add https://github.com/jurisupport/jurisupport-plugins --skill clean-legal-db
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: clean-legal-db
Source: https://github.com/jurisupport/jurisupport-plugins/tree/main/skills/clean-legal-db
Command: npx skills add https://github.com/jurisupport/jurisupport-plugins --skill clean-legal-db

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This Skill provides fast, offline legal research by querying a local SQLite database containing statutes, regulations, and precedents, reducing time spent on online lookups and ensuring reproducible results.

Core Features & Use Cases

  • Offline keyword search using SQLite FTS5 with trigram indexing and a two-character LIKE fallback for broad matches.
  • Coverage across major legal materials (statutes, local regulations, case law, administrative decisions, and interpretive guidance).
  • Use Case: quickly verify a legal provision or locate supporting authorities when drafting a memo or preparing submissions.

Quick Start

Query the local legal database with a keyword to retrieve statutes, cases, or rulings, for example search for '유류분'.

Frequently Asked Questions about clean-legal-db

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

FAQPage Schema
How do I search statutes and case law offline without an internet connection?

Offline legal research is performed by querying a local SQLite database containing statutes, regulations, and precedents, which retrieves primary materials without external dependencies. This ensures fast, reproducible results during memo preparation.

What is trigram full-text search and how does it work for legal databases?

Trigram full-text search uses SQLite FTS5 trigram indexing to match keywords within legal materials. It falls back to a two-character LIKE query for broad matches, ensuring comprehensive retrieval of statutes and case law.

Can I use this offline legal database to verify statutory references for a memo?

Yes, you can query the local legal database to verify legal provisions and locate controlling authorities. It outputs source citations to primary materials, making it suitable for preparing memos and submissions.

Does this offline legal search tool require any external dependencies or API connections?

No, the legal database search operates entirely offline using a local SQLite database. It requires no external dependencies or API connections, ensuring reproducible results for legal research tasks.

What types of legal materials are covered by this offline SQLite database?

The offline SQLite database covers major legal materials including statutes, local regulations, case law, administrative decisions, and interpretive guidance. This broad coverage supports various legal research and citation verification tasks.

Why use an offline SQLite legal database instead of online lookup tools?

An offline SQLite legal database reduces time spent on online lookups and ensures reproducible results. It is ideal for environments without internet access or when verifying statutory references quickly during drafting.