mcp-server-libsql

MCP.Pizza Chef: nicholasq

The mcp-server-libsql is a Model Context Protocol server designed to interface seamlessly with LibSQL databases. Built on Deno 2.1+, it provides structured access to database schemas, supports executing SQL queries, and handles prompt completions. This server supports both authenticated and unauthenticated connections, offering flexibility and security for developers integrating LibSQL into their applications. It enables real-time, model-driven interactions with LibSQL data sources, making it ideal for AI-enhanced workflows and applications requiring dynamic database context.

Use This MCP server To

Access LibSQL database schemas for AI context Execute SQL queries via MCP protocol Enable prompt completions using LibSQL data Integrate LibSQL with AI agents securely Support authenticated and unauthenticated DB access

README

LibSQL Model Context Protocol Server

The LibSQL Model Context Protocol Server is a server application designed to interface with LibSQL databases, providing schema information and enabling table queries. Built using Deno 2.1, this server leverages the Model Context Protocol (MCP) to handle various requests such as listing resources, reading resource schemas, completing prompts, and executing SQL queries. It supports both authenticated and unauthenticated access to LibSQL databases, ensuring flexibility and security. This project is ideal for developers looking to integrate LibSQL database functionalities into their applications seamlessly.

Requirements

  • Deno 2.1+
  • A LibSQL database URL

Usage

Install deno (macos/linux):

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

Build the binary:

deno run build

Run the server:

# If accessing a local libsql db that does not require auth
./mcp-server-libsql <database-url>

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

License

This project is licensed under the MIT License - see the LICENSE.txt file for details.

mcp-server-libsql FAQ

How do I install the mcp-server-libsql?
Install Deno 2.1+ from deno.land, then build the server binary using 'deno run build'.
Can mcp-server-libsql connect to remote LibSQL databases?
Yes, it supports connecting to any LibSQL database via its URL, including remote instances.
Does mcp-server-libsql support authentication?
Yes, it supports both authenticated and unauthenticated access to LibSQL databases for flexible security.
What environment is required to run mcp-server-libsql?
It requires Deno runtime version 2.1 or higher on macOS or Linux systems.
How does mcp-server-libsql handle SQL query execution?
It processes SQL queries through the MCP protocol, returning structured results to the client.
Is mcp-server-libsql compatible with multiple LLM providers?
Yes, it works with models from OpenAI, Anthropic Claude, and Google Gemini by providing structured database context.
Can I use mcp-server-libsql for real-time AI workflows?
Absolutely, it enables dynamic, real-time access to LibSQL data for AI-enhanced applications.
How do I run the server after building?
Execute the binary with the LibSQL database URL as an argument, e.g., './mcp-server-libsql <database-url>'.