xexr/mcp-libsql

MCP libSQL by xexr

A Model Context Protocol (MCP) server for libSQL database operations, providing secure database access through Claude Desktop, Claude Code, Cursor, and other MCP-compatible clients.

Runs on Node, written in TypeScript

🔧 Quick Start

1. Install:

   pnpm install -g @xexr/mcp-libsql
   

2. Test locally:

   mcp-libsql --url file:///tmp/test.db --log-mode console
   

3. Configure Claude Desktop with your Node.js path and database URL (see configuration examples below)

🚀 Status

✅ Complete database management capabilities - All 6 core tools implemented and tested
✅ Comprehensive security validation - 67 security tests covering all injection vectors
✅ Extensive test coverage - 244 total tests (177 unit + 67 security) with 100% pass rate
✅ Production deployment verified - Successfully working with MCP clients
✅ Robust error handling - Connection retry, graceful degradation, and audit logging

🛠️ Features

Available Tools

• read-query: Execute SELECT queries with comprehensive security validation
• write-query: INSERT/UPDATE/DELETE operations with transaction support
• create-table: DDL operations for table creation with security measures
• alter-table: Table structure modifications (ADD/RENAME/DROP operations)
• list-tables: Database metadata browsing with filtering options
• describe-table: Table schema inspection with multiple output formats