libSQL by xexr

by Xexr

21 stars

430 downloads

Not rated

GitHub

About

MCP server for libSQL databases with comprehensive security and management tools. Supports file, local HTTP, and remote Turso databases with connection pooling, transaction support, and 6 specialized database tools.

Details

Author: Xexr
GitHub stars: 21
Downloads: 430
Categories: Database, Community, Other

- 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

Setting up with Highlight

This MCP is not yet compatible with Highlight’s one-click setup. However, you can still use it with Highlight by following these steps:

Download and install Highlight from highlightai.com/download
Navigate to the plugins tab and select "Add Custom Plugin"
Configure the plugin with the settings below

Plugin Name libSQL by xexr

Command (node, npx, python, etc.)

Please refer to the README for specific instructions on how to obtain API keys or other required environment variables.
Enable "Start Automatically" if you want the plugin to start when Highlight launches

Setting up with Cursor

Open Cursor's settings
Navigate to the MCP section
Click "Add new Global MCP server"
Copy and paste the configuration below based on your operating system

JSON

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

JSON

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

JSON

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

Setting up with Claude Desktop

Open Claude Desktop's settings
Go to the Integrations tab
Click "Add MCP Server"
Use the configuration below based on your operating system

Note: Make sure Claude Desktop is running before attempting to connect.

JSON

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

JSON

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

JSON

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

Setting up with Windsurf

Open Windsurf's preferences
Go to the Integrations section
Click "Add MCP Integration"
Use the configuration below based on your operating system

JSON

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

JSON

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

JSON

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

Setting up with Cline

Open Cline's settings
Navigate to the Integrations section
Click "Add MCP Server"
Copy and paste the configuration below based on your operating system

Note: Make sure to restart Cline after adding the configuration.

JSON

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

JSON

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

JSON

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

Setting up with Goose

Open Goose's preferences
Go to the Integrations tab
Select "MCP Servers"
Click "Add New Server"
Use the configuration below based on your operating system

JSON

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

JSON

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

JSON

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

From the repository

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.

Claude Desktop / Cursor

Paste into your MCP client config file to install this server.

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

McpServers

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

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

Security & Reliability

- Multi-layer SQL injection prevention with comprehensive security validation - Connection pooling with health monitoring and automatic retry logic - Transaction support with automatic rollback on errors - Comprehensive audit logging for security compliance

> 🔐 Security details: See docs/SECURITY.md for comprehensive security features and testing.

Developer Experience

- Beautiful table formatting with proper alignment and NULL handling - Performance metrics displayed for all operations - Clear error messages with actionable context - Parameterized query support for safe data handling - Development mode with enhanced logging and hot reload

📋 Prerequisites

- Node.js 20+
- pnpm (or npm) package manager
- libSQL database (file-based or remote)
- Claude Desktop (for MCP integration)

Platform Requirements

- macOS: Native Node.js installation - Linux: Native Node.js installation - Windows: Native Node.js installation or WSL2 with Node.js installation

🔧 Installation

```bash

No reviews yet — be the first

Use Google, GitHub, or an email account so ratings stay tied to real people.

Email sign in

No reviews posted yet.

About

Details

Jump to

Setting up with Highlight

From the repository

Claude Desktop / Cursor

McpServers

MCP libSQL by xexr

🔧 Quick Start

🚀 Status

🛠️ Features

Available Tools

Security & Reliability

Developer Experience

📋 Prerequisites

Platform Requirements

🔧 Installation

Install

More like this

Sequential Thinking

Redis

Filesystem

EverArt

Google Drive

Sqlite