mcp-libsql

Overview

MCP libSQL is a robust Model Context Protocol server that enables secure database operations through libSQL. Built with TypeScript, it provides 6 comprehensive tools for read/write queries, table management, and schema inspection. The server includes extensive security measures with 67 security tests preventing SQL injection attacks, connection pooling with health monitoring, and transaction support with automatic rollback on errors. It's fully tested with 244 test cases covering functionality, edge cases, and security scenarios, and has been verified for production use with Claude Desktop, Claude Code, and other MCP clients.

Try asking AI

After installing, here are 5 things you can ask your AI assistant:

• read-query

  Execute SELECT queries with security validation

  Try:Show me all users from the customers tableTry:Select the top 10 orders by order date
• write-query

  INSERT/UPDATE/DELETE with transaction support

  Try:Insert a new user into the users tableTry:Update the price for product ID 123
• create-table

  CREATE TABLE with DDL security

  Try:Create a new products table with id, name, and price columnsTry:Make a table for storing user feedback
• alter-table

  Modify table structure (ADD/RENAME/DROP)

  Try:Add a new column to the orders tableTry:Rename the customers table to users
• list-tables

  Browse database metadata and objects

  Try:Show all tables in the databaseTry:List all tables that start with 'user'
• describe-table

  Inspect table schema and structure

  Try:Describe the structure of the orders tableTry:Show me the columns and data types for products

Comparable tools

Installation

# Install globally
pnpm install -g @xexr/mcp-libsql

{
  "mcpServers": {
    "mcp-libsql": {
      "command": "mcp-libsql",
      "args": [
        "--url",
        "file:///Users/username/database.db"
      ]
    }
  }
}

export LIBSQL_AUTH_TOKEN="your-turso-auth-token-here"

{
  "mcpServers": {
    "mcp-libsql": {
      "command": "mcp-libsql",
      "args": [
        "--url",
        "libsql://your-database.turso.io"
      ]
    }
  }
}

FAQ

How do I handle authentication for Turso databases?

You can either use environment variables (recommended) or CLI parameters. For environment variables, export LIBSQL_AUTH_TOKEN with your token. For CLI parameters, add --auth-token to your command in Claude Desktop configuration.

What SQL injection prevention features are included?

The server includes multi-layer SQL injection prevention with comprehensive security validation, implementing 67 security tests covering all injection vectors. It uses parameterized queries and input validation to ensure safe database operations.

Compare mcp-libsql with