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.
コメント