SQLite

概要

SQLite is a robust Model Context Protocol (MCP) server designed to provide a comprehensive interface for interacting with SQLite databases. Built with FastMCP, this server empowers LLM agents to seamlessly execute a wide array of database operations. Agents can open and close database files, perform full CRUD (Create, Read, Update, Delete) operations on tables and records, execute raw SQL SELECT queries, and inspect database schemas by listing tables and viewing their definitions. This tool acts as a crucial bridge, allowing AI agents to efficiently manage and manipulate data within SQLite databases with full type safety and robust error handling.

主な機能

• Schema Inspection: List all tables and retrieve detailed table schemas.
• Type-Safe: Includes comprehensive type hints and error handling for reliable operations.
• CRUD Operations: Create tables, insert, read, update, and delete records.
• Database Management: Open and close SQLite database files.
• 0 GitHub stars
• Query Execution: Execute raw SQL SELECT queries with parameterized inputs.

ユースケース

• Allowing LLM agents to insert, update, and delete data records within a SQLite database based on task requirements.
• Enabling LLM agents to query and retrieve specific data from SQLite databases using natural language prompts translated into SQL.
• Empowering LLM agents to programmatically create and manage database schemas (tables).