Trino

소개

The Trino MCP server offers a powerful and secure solution for interacting with the Trino query engine through the Model Context Protocol. It streamlines data exploration and SQL execution by providing an array of tools to list catalogs, schemas, and tables, describe their structures, and execute both read-only and write SQL queries. With support for multiple authentication methods, including OAuth2, Azure Service Principal (SPN) with automatic token refresh, and basic username/password, it ensures flexible and secure connectivity. Enhanced safety features like write protection and query watermarking for auditing purposes make it a reliable choice for managing Trino operations.

주요 기능

• Azure Service Principal (SPN) with Auto-Refresh for tokens
• Query Watermarking for tracking and auditing SQL queries
• Core Trino Operations (Query catalogs, schemas, tables, execute SQL)
• 0 GitHub stars
• Write Protection for preventing accidental database modifications
• Multiple Authentication Methods (OAuth2, Azure SPN, basic, none)

사용 사례

• Securely connecting to Trino clusters in CI/CD pipelines using Azure Service Principal
• Executing SQL queries and managing Trino data with built-in safety features
• Integrating Trino query capabilities into VS Code or Claude Desktop environments