MCP libSQL Server

Example Use Cases

• 1

  Run parameterized SELECT queries against a libSQL/Turso or file-based SQLite database with built-in SQL injection prevention and result formatting.

• 2

  Perform safe write operations (INSERT/UPDATE/DELETE) and manage schema changes (CREATE/ALTER TABLE) with transaction support and audit logging.

• 3

  Integrate a local or remote libSQL database into MCP workflows (Claude Desktop, Claude Code, Cursor) for interactive querying, metadata browsing, and schema inspection.

Description

MCP libSQL is a Node.js TypeScript MCP server that lets MCP-compatible clients execute queries and manage libSQL (file, HTTP, Turso) databases securely. It implements a tool-based API (read-query, write-query, create-table, alter-table, list-tables, describe-table) with connection pooling, transaction support, audit logging, and multi-layer SQL injection protection. The project emphasizes developer experience with formatted outputs, performance metrics, and comprehensive testing and security validation.