LibSQL

Provides MCP access to LibSQL databases, exposing schemas, resources, prompts, and SQL queries via authenticated or unauthenticated access.

typescript

0

GitHub Stars

typescript

Language

4 months ago

First Indexed

3 weeks ago

Catalog Refreshed

Documentation & install

Readme and setup notes from the catalogue, plus a client-ready config you can copy for your MCP host.

Installation

Add the following to your MCP client configuration file.

Configuration

View docs

{
  "mcpServers": {
    "mcp-mirror-nicholasq_mcp-server-libsql": {
      "command": "./mcp-server-libsql",
      "args": [
        "<database-url>"
      ]
    }
  }
}

You can connect to LibSQL databases through the MCP server to retrieve schemas, list resources, complete prompts, and execute SQL queries. It supports both authenticated and unauthenticated access, giving you flexible options for development and production workflows.

How to use

Use a MCP client to interact with the LibSQL MCP server. You can list available resources, query schemas, complete prompts, and run SQL statements against your LibSQL database. Choose whether to authenticate with an auth token or connect anonymously depending on your security needs.

Run the server locally with an unprotected database URL to enable unauthenticated access, or provide an authentication token to enable authenticated access. The server exposes a straightforward runtime that accepts a database URL and optional authentication token.

./mcp-server-libsql <database-url>

./mcp-server-libsql --auth-token <token> <database-url>

How to install

Prerequisites you need before installing and running the MCP server: Deno 2.1 or newer and access to a LibSQL database URL.

Install Deno if you have not already done so.

curl -fsSL https://deno.land/install.sh | sh

Build the MCP server binary using Deno.

den o run build

Run the server with an unauthenticated connection.

./mcp-server-libsql <database-url>

Run the server with authentication enabled.

./mcp-server-libsql --auth-token <token> <database-url>

Additional sections

Notes on usage and security: you can choose to expose the MCP server with or without authentication. When using authentication, protect the auth token and limit access to trusted clients. Both modes support the full MCP feature set, including resource listing, schema reads, prompt completions, and SQL execution.

Available tools

list_resources

Lists available LibSQL resources such as schemas and databases.

read_schema

Reads and returns the schema for a specified resource or table.

complete_prompts

Provides prompt completion capabilities using the LibSQL MCP endpoints to assist query construction.

execute_sql

Executes raw SQL queries against the LibSQL database and returns results.