概要
What is MCP libSQL by xexr?
MCP libSQL by xexr is a Model Context Protocol server for libSQL database operations. It provides secure database access through Claude Desktop, Claude Code, Cursor, and other MCP-compatible clients. Runs on Node, written in TypeScript.
How to use MCP libSQL by xexr?
Install globally via pnpm install -g @xexr/mcp-libsql. Test locally with mcp-libsql --url file:///tmp/test.db --log-mode console. Then configure the MCP server in your client using the command mcp-libsql with arguments --url and the database URL. Supports file (file://), HTTP, and Turso (libsql://) databases. Authentication is provided via the LIBSQL_AUTH_TOKEN environment variable or the --auth-token CLI parameter.
Key features of MCP libSQL by xexr
- 6 core tools: read-query, write-query, create-table, alter-table, list-tables, describe-table
- Multi-layer SQL injection prevention with 67 security tests
- Connection pooling with health monitoring and automatic retry
- Transaction support with automatic rollback on errors
- Comprehensive audit logging for security compliance
- Beautiful table formatting with performance metrics
Use cases of MCP libSQL by xexr
- Managing local libSQL databases through an AI assistant
- Connecting Claude Desktop to a Turso cloud database
- Securely executing SQL queries with transaction support
- Inspecting database schema and browsing metadata
- Integrating libSQL operations into MCP-compatible workflows
FAQ from MCP libSQL by xexr
What are the prerequisites?
Node.js 20+, pnpm (or npm), a libSQL database (file-based or remote), and Claude Desktop for MCP integration.
How do I authenticate with Turso?
Use the LIBSQL_AUTH_TOKEN environment variable or the --auth-token CLI parameter when starting the server. Environment variables are safer.
What logging modes are available?
--log-mode accepts: file (default), console, both, or none. Console mode is useful for development debugging.
How is security implemented?
Multi-layer SQL injection prevention with 67 security tests, connection pooling with health monitoring, automatic retry logic, and comprehensive audit logging.
Which platforms are supported?
macOS, Linux, and Windows (using WSL2). Use native Node.js installations on macOS/Linux, WSL2 with Node.js on Windows.
