MCP libSQL by xexr

Name: MCP libSQL by xexr
Author: Xexr

@Xexr

关于 MCP libSQL by xexr

Secure MCP server for libSQL databases with comprehensive tools, connection pooling, and transaction support. Built with TypeScript for Claude Desktop, Claude Code, Cursor, and other MCP clients.

#sql #database #sqlite #mcp #sqlite3 #claude #ai-tools #turso #libsql #turso-db #model-context-protocol #mcp-server #mcp-tools #model-context-protocol-servers

基本信息

分类

数据库

许可证

MIT

运行时

node

传输方式

stdio

发布者

Xexr

配置

使用下面的配置,将此服务器添加到你的 MCP 客户端。

{
  "mcpServers": {
    "mcp-libsql": {
      "command": "node",
      "args": [
        "dist/index.js",
        "-v",
        "#",
        "check",
        "version"
      ]
    }
  }
}

工具

未检测到工具

工具是从 README 中自动提取的。维护者可以在 ## Tools 标题下列出工具,即可填充这部分内容。

概览

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.