Connect Snowflake Cortex to Prometheux

Connect Snowflake to Prometheux using the Remote MCP Server. By registering Prometheux as an external MCP connector, Snowflake's AI features gain the ability to list concepts, run reasoning, and query knowledge graphs — directly within Snowflake.

The same MCP connector works with both:

• Cortex Code — Snowflake's AI coding assistant in Snowsight
• Snowflake Intelligence — Cortex Agents for data exploration and orchestration

Native App Users

If you're using the Prometheux Snowflake Native App, Cortex Agents and Snowflake Intelligence can access Prometheux tools automatically via the built-in CUSTOM MCP SERVER — no external MCP connector or OAuth setup needed. See the Native App installation guide for details.

The setup below is for connecting Snowflake to the cloud-hosted Prometheux platform (SaaS) via the Remote MCP Server.

Prerequisites

• Snowflake account with ACCOUNTADMIN role
• Prometheux credentials (username, organization, API token)
• MCP Connectors enabled on your account (supports Cortex Code and Cortex Agents)
• Cross-region inference enabled (required if no models are available in your region)

Cross-Region Inference

If your Snowflake region doesn't have LLM models available locally, enable cross-region inference first:

ALTER ACCOUNT SET CORTEX_ENABLED_CROSS_REGION = 'ANY_REGION';

Without this, agent creation will fail with a "model not authorized" error.

Setup

Step 1 — Create the API Integration

Run the following SQL in a Snowsight worksheet as ACCOUNTADMIN:

USE ROLE ACCOUNTADMIN;

CREATE API INTEGRATION prometheux_mcp_integration
  API_PROVIDER = external_mcp
  API_ALLOWED_PREFIXES = ('https://api.prometheux.ai/px-remote-mcp-server')
  API_USER_AUTHENTICATION = (
    TYPE = OAUTH2
    OAUTH_CLIENT_ID = 'prometheux'
    OAUTH_CLIENT_SECRET = 'unused'
    OAUTH_TOKEN_ENDPOINT = 'https://api.prometheux.ai/px-remote-mcp-server/oauth/token'
    OAUTH_AUTHORIZATION_ENDPOINT = 'https://api.prometheux.ai/px-remote-mcp-server/oauth/authorize'
    OAUTH_CLIENT_AUTH_METHOD = CLIENT_SECRET_POST
  )
  ENABLED = TRUE;

Field	Value
API_PROVIDER	external_mcp
OAUTH_CLIENT_ID	prometheux
OAUTH_CLIENT_SECRET	Any non-empty value (e.g. unused)
OAUTH_TOKEN_ENDPOINT	https://api.prometheux.ai/px-remote-mcp-server/oauth/token
OAUTH_AUTHORIZATION_ENDPOINT	https://api.prometheux.ai/px-remote-mcp-server/oauth/authorize
OAUTH_CLIENT_AUTH_METHOD	CLIENT_SECRET_POST

Step 2 — Create the External MCP Server

Create a database and schema to hold the MCP server object (or use an existing one):

CREATE DATABASE IF NOT EXISTS PROMETHEUX;
CREATE SCHEMA IF NOT EXISTS PROMETHEUX.INTEGRATION;

USE DATABASE PROMETHEUX;
USE SCHEMA INTEGRATION;

CREATE EXTERNAL MCP SERVER prometheux_mcp_server
  WITH DISPLAY_NAME = 'Prometheux'
  URL = 'https://api.prometheux.ai/px-remote-mcp-server/mcp'
  API_INTEGRATION = prometheux_mcp_integration;

Step 3 — Connect and Authenticate

After creating the MCP server object, it appears in the MCP Connectors page in Snowsight. You need to authenticate once per user:

1. In Snowsight, go to the MCP Connectors page (or open it from Cortex Code / Snowflake Intelligence)
2. Find Prometheux in the list of connectors
3. Click Connect — Snowflake will redirect you to the Prometheux OAuth login page
4. Enter your credentials:
   • Username: Your Prometheux username
   • Organization: Your Prometheux organization
   • API Token: Your Prometheux authentication token
5. Submit the form — Snowflake will receive your session token automatically

The connector should now show as Connected.

Using with Cortex Code

Once connected, Prometheux tools are available in Cortex Code (Snowflake's AI coding assistant in Snowsight). Interact naturally — Cortex Code will automatically discover and invoke Prometheux tools based on your queries.

Example:

@MCP list all of my projects

Using with Snowflake Intelligence

To use the connector with Cortex Agents in Snowflake Intelligence, create an agent that references the MCP server:

CREATE AGENT PROMETHEUX.INTEGRATION.prometheux_agent
  COMMENT = 'Agent with Prometheux MCP connector'
  FROM SPECIFICATION
  $$
  models:
    orchestration: "auto"
  mcp_servers:
    - server_spec:
        name: "PROMETHEUX.INTEGRATION.PROMETHEUX_MCP_SERVER"
  $$;

Using an existing agent

To add Prometheux to an existing agent, navigate to AI & ML → Agents in Snowsight, select your agent, and add the Prometheux connector from the MCP Connectors section.

Then open the agent in Snowflake Intelligence and interact with it naturally. The agent will discover and invoke Prometheux tools based on your queries.

Available Tools

See the MCP overview page for the complete list of tools exposed via MCP.

Alternative Setup via Snowsight UI

You can also add the connector through the Snowsight UI instead of SQL:

1. Go to AI & ML → Agents → Settings → Tools and Connectors
2. Click Add custom
3. Select Standard OAuth and fill in:

Field	Value
Name	Prometheux
Description	Connect to Prometheux ontologies
Server URL	https://api.prometheux.ai/px-remote-mcp-server/mcp
Token endpoint	https://api.prometheux.ai/px-remote-mcp-server/oauth/token
Authorization endpoint	https://api.prometheux.ai/px-remote-mcp-server/oauth/authorize
OAuth Client ID	prometheux
OAuth Client Secret	unused
Scopes	openid

4. Select a database and schema, then click Add

Disconnecting

To disconnect the Prometheux connector:

1. Go to the MCP Connectors page in Snowsight
2. Select the Prometheux connector and click Disconnect

You can also disconnect from within Snowflake Intelligence by opening the Sources panel and clicking Manage Connections.

Cleanup

To fully remove the Prometheux integration:

DROP AGENT PROMETHEUX.INTEGRATION.PROMETHEUX_AGENT;
DROP EXTERNAL MCP SERVER PROMETHEUX.INTEGRATION.PROMETHEUX_MCP_SERVER;
DROP API INTEGRATION PROMETHEUX_MCP_INTEGRATION;

Troubleshooting

"Invalid redirect_uri" error

Solution:

• This occurs if the Prometheux remote MCP server doesn't recognize Snowflake's OAuth callback. Ensure you're connecting to the latest version of the remote server at https://api.prometheux.ai/px-remote-mcp-server.

"Model not authorized" error

Solution:

• Enable cross-region inference on your account:

  ALTER ACCOUNT SET CORTEX_ENABLED_CROSS_REGION = 'ANY_REGION';

• Alternatively, check which models are available in your region and set a specific model in the agent specification instead of "auto".

Connector shows "Connected" but tools don't work

Solution:

• If the remote MCP server was restarted, session tokens are invalidated. Disconnect and reconnect via the Sources panel in Snowflake Intelligence.
• Verify your Prometheux credentials are still valid.

"Failed to add MCP connector" in the UI

Solution:

• Use the SQL-based setup instead. The Snowsight UI may fail silently if the server is temporarily unreachable.
• Ensure the MCP server URL is accessible from Snowflake's network.

Agent can't find the MCP server object

Solution:

• Verify the fully qualified name matches exactly (e.g. PROMETHEUX.INTEGRATION.PROMETHEUX_MCP_SERVER).
• Ensure the ACCOUNTADMIN role has USAGE on the database and schema.

For general troubleshooting, see the Remote MCP Server troubleshooting section.