MCP.so
登录

MCP Turso Cloud

@spences10

基本信息

分类

数据库

许可证

MIT

传输方式

stdio

作者

spences10

关于 MCP Turso Cloud

🗂️ A Model Context Protocol (MCP) server that provides integration with Turso databases for LLMs. This server implements a two-level authentication system to handle both organization-level and database-level operations, making it easy to manage and query Turso databases directly

MCP Turso Cloud 配置

使用下面的配置,将此服务器添加到你的 MCP 客户端。

{
  "mcpServers": {
    "mcp-turso-cloud": {
      "command": "npx",
      "args": [
        "-y",
        "mcp-turso-cloud"
      ],
      "env": {
        "TURSO_API_TOKEN": "your-turso-api-token",
        "TURSO_ORGANIZATION": "your-organization-name",
        "TURSO_DEFAULT_DATABASE": "optional-default-database"
      }
    }
  }
}

MCP Turso Cloud 工具

9

List all databases in your Turso organization

✓ SAFE: Create a new database in your Turso organization. Database name must be unique.

⚠️ DESTRUCTIVE: Permanently deletes a database and ALL its data. Cannot be undone. Always confirm with user before proceeding and verify correct database name.

Generate a new token for a specific database

Lists all tables in a database

✓ SAFE: Execute read-only SQL queries (SELECT, PRAGMA, EXPLAIN). Automatically rejects write operations.

⚠️ DESTRUCTIVE: Execute SQL that can modify/delete data (INSERT, UPDATE, DELETE, DROP, ALTER). Always confirm with user before destructive operations.

Gets schema information for a table

Performs vector similarity search

概览

What is mcp-turso-cloud?

mcp-turso-cloud is an MCP server that integrates Turso databases with LLMs. It provides a two-level authentication system for organization-level and database-level operations, enabling LLMs to manage and query Turso databases directly.

How to use mcp-turso-cloud?

Configure it in your MCP client using npx with environment variables: TURSO_API_TOKEN, TURSO_ORGANIZATION, and optionally TURSO_DEFAULT_DATABASE, TOKEN_EXPIRATION, and TOKEN_PERMISSION. Then use the provided MCP tools to interact with your Turso databases.

Key features of mcp-turso-cloud

  • List, create, and delete databases in your Turso organization
  • Generate authentication tokens for specific databases
  • Execute read-only SQL queries (SELECT, PRAGMA) safely
  • Execute destructive SQL queries (INSERT, UPDATE, DELETE, etc.)
  • List tables and describe table schemas
  • Perform vector similarity search using SQLite vector extensions

Use cases of mcp-turso-cloud

  • An LLM lists all databases in a Turso organization to get an overview.
  • An LLM creates a new database and then generates a read-only token for it.
  • An LLM runs a SELECT query to retrieve customer data from a database.
  • An LLM inserts new records into a table after manual approval.
  • An LLM performs a vector search on embeddings stored in a Turso database.

常见问题

1

How does the two-level authentication work?

The server uses a Turso Platform API token for organization-level operations (managing databases) and database-specific tokens for database-level operations. Database tokens are generated automatically from the organization token and cached.

2

What environment variables are required?

You must set `TURSO_API_TOKEN` (your Turso Platform API token) and `TURSO_ORGANIZATION` (your Turso organization name). Optional variables include `TURSO_DEFAULT_DATABASE`, `TOKEN_EXPIRATION` (default '7d'), and `TOKEN_PERMISSION` (default 'full-access').

3

What security separation exists between query types?

Read-only queries (SELECT, PRAGMA) use the `execute_read_only_query` tool, while destructive queries (INSERT, UPDATE, DELETE, etc.) use `execute_query`. This allows different approval levels—read-only can be auto-approved, while destructive operations require explicit review.

4

What tools are provided for database operations?

Database tools include `list_tables`, `execute_read_only_query`, `execute_query`, `describe_table`, and `vector_search`. Organization tools include `list_databases`, `create_database`, `delete_database`, and `generate_database_token`.

5

What are the dependencies or runtime requirements?

The server runs via Node.js and is distributed as an npm package. It uses the Model Context Protocol, Turso, and libSQL. You can run it with `npx mcp-turso-cloud` after setting environment variables.

评论

数据库 分类下的更多 MCP 服务器