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.

Which platforms are supported?

macOS, Linux, and Windows (using WSL2). Use native Node.js installations on macOS/Linux, WSL2 with Node.js on Windows.

「データベース」の他のコンテンツ

MCP Server for MySQL based on NodeJS

benborla

A Model Context Protocol server that provides read-only access to MySQL databases. This server enables LLMs to inspect database schemas and execute read-only queries.

1.9K