jdbc

jdbc is a cursor rule for coding agents from sfc-gh-cconner/support-rules-mcp. It costs 1,472 tokens per session, scanned A, original, Apache-2.0.

A set of guidance for using Java Database Connectivity (JDBC), a standard way for Java programs to connect to databases, with Snowflake.

In plain words
What is it for?
Use it to examine Snowflake JDBC driver code, search for connection errors and retry logic, and investigate session handling and authentication.
Why use it?
It gives developers focused patterns for investigating connection, session, authentication, and driver issues in Java applications.

Cursor rule

Install

Getting it into your agent

One page per mod, every tool's command on it. A separate URL per tool would split the same page into five that compete with each other.

agentmods
npx agentmods add rules/sfc-gh-cconner/support-rules-mcp/jdbc
Clone the repo
git clone --depth 1 https://github.com/sfc-gh-cconner/support-rules-mcp

Wrote this? Show the measurements

A badge with what this costs and how it scanned, read live from this page, so it follows the numbers instead of freezing them. Markdown for a README, HTML for a documentation site or a project page.

agentmods badge for jdbc

README.md
[![agentmods](https://agentmods.dev/badge/rules/sfc-gh-cconner/support-rules-mcp/jdbc.svg)](https://agentmods.dev/rules/sfc-gh-cconner/support-rules-mcp/jdbc)
Your own site
<a href="https://agentmods.dev/rules/sfc-gh-cconner/support-rules-mcp/jdbc"><img src="https://agentmods.dev/badge/rules/sfc-gh-cconner/support-rules-mcp/jdbc.svg" alt="Measured on agentmods" height="20"></a>
Per session 1,472 This file is loaded in full into every session.
When invoked 1,472 The same file — it is already loaded in full.
Security scan A 0 findings. Scan, not verified.
Origin original No closer match found in the catalogue.
Token cost

What it costs to keep this loaded

Counted locally with the o200k_base tokenizer, which is exact for GPT models; Claude uses its own tokenizer and its counts differ. Treat this as one consistent yardstick across the catalogue rather than a bill. Prices are per million input tokens.

ModelPer sessionOnce invoked
Fable 5 $0.01472 $0.01472
Opus 5 $0.00736 $0.00736
Sonnet 5 $0.00294 $0.00294
Haiku 4.5 $0.00147 $0.00147

Measured 3d ago against content hash 3c1d344e4a8d, method: parsed. Prices are Anthropic first-party input rates as of 2026-08-30, from the pricing page.

Security

Grade A, and why

jdbc scanned grade A with 0 findings against 26 rules in 11 categories — prompt injection, anti-refusal, data exfiltration, privilege escalation, supply chain, agent snooping, system-prompt leakage, SSRF and excessive agency — measured 3d ago.

A static scan of the body, not an audit. Every finding is printed with the line that produced it so you can judge whether it matters here. A mod is markdown that instructs an agent; that is exactly why what it instructs is worth reading.

Nothing flagged

None of the 26 patterns this scan looks for appear in this file: no shell pipes, no recursive deletes, no credential paths, no hidden text, no instruction-override or anti-refusal phrasing, no agent-config snooping. That is not a guarantee, it is the absence of the things that are checkable.

rules/connectors/jdbc.mdc · 241 lines

How it starts

The opening of the file, as written. The whole thing — 241 lines — stays where its author put it; the contents beside it link to each section on GitHub.

Snowflake JDBC Driver Investigation Guide

PURPOSE: JDBC driver patterns for Java applications connecting to Snowflake.

Access Method: GitHub MCP API tools
Repository: snowflakedb/snowflake-jdbc

🔍 Quick Investigation Patterns

Connection Issues

# Search for connection errors
mcp_github_search_code(
    query='"Connection refused" OR "Connection timeout" repo:snowflakedb/snowflake-jdbc'
)

# Get connection implementation
mcp_github_get_file_contents(
    owner="snowflakedb",
    repo="snowflake-jdbc",
    path="src/main/java/net/snowflake/client/core/SFSession.java"
)

# Search for retry logic
mcp_github_search_code(
    query='HttpUtil OR RestRequest repo:snowflakedb/snowflake-jdbc'
)

Session Management

# Search for session errors
mcp_github_search_code(
    query='"Session no longer exists" OR "Session expired" repo:snowflakedb/snowflake-jdbc'
)

# Get session handling
mcp_github_get_file_contents(
    owner="snowflakedb",
    repo="snowflake-jdbc",
    path="src/main/java/net/snowflake/client/core/SessionUtil.java"
)

# Search for heartbeat
mcp_github_search_code(
    query='heartbeat OR HeartbeatBackground repo:snowflakedb/snowflake-jdbc'
)

Authentication

# Search for auth implementations
mcp_github_search_code(
    query='path:src/main/java/net/snowflake/client/core/auth repo:snowflakedb/snowflake-jdbc'
)

# Get authenticator factory
mcp_github_get_file_contents(
    owner="snowflakedb",
    repo="snowflake-jdbc",
    path="src/main/java/net/snowflake/client/core/auth/AuthenticatorFactory.java"
)

🎯 Key Components

Core Classes

# Main driver class
mcp_github_get_file_contents(
    owner="snowflakedb", repo="snowflake-jdbc",
    path="src/main/java/net/snowflake/client/jdbc/SnowflakeDriver.java"
)

# Connection implementation
mcp_github_get_file_contents(
    owner="snowflakedb", repo="snowflake-jdbc",
    path="src/main/java/net/snowflake/client/jdbc/SnowflakeConnectionV1.java"
)

# Statement execution
mcp_github_get_file_contents(
    owner="snowflakedb", repo="snowflake-jdbc",
    path="src/main/java/net/snowflake/client/jdbc/SnowflakeStatementV1.java"
)

# Result set handling
mcp_github_get_file_contents(
    owner="snowflakedb", repo="snowflake-jdbc",
    path="src/main/java/net/snowflake/client/jdbc/SnowflakeResultSetV1.java"
)

Read the full file on GitHub · 241 lines

Changes

What this file has done since we first saw it

Hashed on every crawl. A supply-chain change to an agent config is a question of when, not whether, so the history is kept rather than the latest state alone.

  1. 3d ago First seen · 241 lines · 1,472 tokens per session scan A 3c1d344e4a8d

Subscribe to this mod's changes

jdbc is a cursor rule published in the GitHub repository sfc-gh-cconner/support-rules-mcp (0 stars, last pushed 10mo ago), licensed Apache-2.0. It adds 1,472 tokens to every session, about $0.0074 per session on Opus 5. A static security scan graded it A with 0 findings. No closer match exists in the catalogue, so it is treated as the original; first seen 2026-08-31.