QueryPie DAC

Securely access databases through QueryPie platform’s DAC (Data Access Control).

Key Features

• Database access through QueryPie DAC (Data Access Control)
• Permission-based database cluster management
• Secure SQL query execution

Basic Information

Authentication Method

Authenticate using QueryPie platform username and password.

Input Parameters

• Server URL (Required): QueryPie API server URL
• Username (Required): QueryPie username
• Password (Required): QueryPie password

Supported MCP Tools

DAC (Data Access Control) Tools

Manage database access through QueryPie’s data access control functionality.

list_accessible_db_cloud_providers

Retrieve a list of all available cloud providers.

list_accessible_db_cluster_groups

Retrieve a list of accessible database cluster groups for a specific cloud provider.

Input Parameters:

• cloudProviderUuid (Required): Cloud provider UUID

list_accessible_db_clusters

Retrieve a list of accessible database clusters for a specific cluster group. You must select a cluster to execute queries.

Input Parameters:

• clusterGroupUuid (Required): Cluster group UUID

run_db_query

Execute SQL queries on the database.

Input Parameters:

• clusterUuid (Required): Cluster UUID
• proxyHost (Required): Proxy host
• proxyPort (Required): Proxy port
• query (Required): SQL query to execute

Usage Examples

For example,

• When you input the prompt “Show me the list of databases accessible through QueryPie”,
• The LLM will sequentially call list_accessible_db_cloud_providers, list_accessible_db_cluster_groups, and list_accessible_db_clusters tools through QueryPie DAC MCP, then respond based on the results.

Precautions

• Keep your QueryPie username and password secure.
• Maintain security through proper permission settings.
• Follow your organization’s security policies when accessing data.
• Regularly review access logs.