Back to search
C
73.7 /100

snowflake-mcp

Author faressoft
Scanned just now

MCP server for executing Snowflake queries

npm

Versions

1.1.0scored
Mar 4, 2026
1.0.0
Mar 3, 2026

Trust breakdown

PermissionsTool SafetyAuthAnnotationsCode QualityStabilitySpecVuln HistoryAuthorTransparencyCommunity

Tools 11

test_connection
annotations: none low

Test the connection to Snowflake and return connection info

execute_query
annotations: none low

Execute a SQL query against Snowflake and return the results

query string
explain_query
annotations: none low

Get the execution plan for a SQL query without running it

query string
list_databases
annotations: none low

List all accessible databases in Snowflake

list_schemas
annotations: none low

List all schemas in a database

list_tables
annotations: none low

List all tables in a schema

schema string database string
list_views
annotations: none low

List all views in a schema

schema string database string
describe_table
annotations: none low

Get detailed information about a table

table string
get_table_sample
annotations: none low

Get a sample of rows from a table to understand its data

table string
get_table_row_count
annotations: none low

Get the total number of rows in a table

table string
get_primary_keys
annotations: none low

Get primary key columns for a table

table string

Permissions 1

env_vars Server uses env_vars capabilities via: process.env
low

Scan Findings 36

low
Tool 'test_connection' has no annotations annotation_checker · 100%
low
Tool 'execute_query' has no annotations annotation_checker · 100%
low
Tool 'explain_query' has no annotations annotation_checker · 100%
low
Tool 'list_databases' has no annotations annotation_checker · 100%
low
Tool 'list_schemas' has no annotations annotation_checker · 100%
low
Tool 'list_tables' has no annotations annotation_checker · 100%
low
Tool 'list_views' has no annotations annotation_checker · 100%
low
Tool 'describe_table' has no annotations annotation_checker · 100%
low
Tool 'get_table_sample' has no annotations annotation_checker · 100%
low
Tool 'get_table_row_count' has no annotations annotation_checker · 100%
low
Tool 'get_primary_keys' has no annotations annotation_checker · 100%
info
Sandbox failed to start for behavioral verification behavioral_verifier · 100%
medium
Vulnerable dependency: @modelcontextprotocol/sdk@1.0.0 (GHSA-6prh-2h8m-c8cw) dependency_analyzer · 95%
medium
Vulnerable dependency: @modelcontextprotocol/sdk@1.0.0 (GHSA-w48q-cv73-mx4w) dependency_analyzer · 95%
medium
Vulnerable dependency: snowflake-sdk@1.14.0 (GHSA-qqj6-54q6-cxv6) dependency_analyzer · 95%
medium
Vulnerable dependency: snowflake-sdk@1.14.0 (GHSA-wmjq-jrm2-9wfr) dependency_analyzer · 95%
medium
Vulnerable dependency: snowflake-sdk@1.14.0 (GHSA-xfhv-wqj6-rx99) dependency_analyzer · 95%
medium
Vulnerable dependency: zod@3.23.8 (GHSA-mrhx-c7xc-m3w5) dependency_analyzer · 95%
info
package.json metadata manifest_parser · 100%
info
Tool: test_connection manifest_parser · 70%
info
Tool: execute_query manifest_parser · 70%
info
Tool: explain_query manifest_parser · 70%
info
Tool: list_databases manifest_parser · 70%
info
Tool: list_schemas manifest_parser · 70%
info
Tool: list_tables manifest_parser · 70%
info
Tool: list_views manifest_parser · 70%
info
Tool: describe_table manifest_parser · 70%
info
Tool: get_table_sample manifest_parser · 70%
info
Tool: get_table_row_count manifest_parser · 70%
info
Tool: get_primary_keys manifest_parser · 70%
info
Transport: stdio manifest_parser · 90%
info
Required env vars (6) manifest_parser · 80%
info
Sandbox failed to start for output poisoning scan output_poisoning · 100%
low
Permission: env_vars access detected permission_analyzer · 90%
info
SBOM generated: 376 components sbom_generator · 100%
medium
No build provenance detected (SLSA L0) slsa_assessor · 90%