Skip to main content
All daily limits reset at midnight UTC.

50 plan calls / day

The plan tool. Direct SQL execution (run) is counted separately.

500,000 tokens / day

LLM token budget for planning. Consumption scales with query complexity and schema size.

500 tables · 3,000 columns

Hard limit per database connection. Scope the connection to a specific schema to stay under the limit.

300 rows per query

Rows returned to your AI client. The Snowflake query runs in full; DataFrey caps what it sends back.

​
Planning & indexing

Planning requires a built index — run datafrey index after connecting your database.
ConstraintValue
Max tables indexed per connection500
Max columns indexed (across all tables)3,000
Daily plan requests50
Daily reindex requests3
Daily LLM token budget500,000 tokens
Per-plan token limit100,000 tokens
Per-table index timeout60 s
Total reindex timeout14 min
Unused token budget doesn’t roll over.
If your schema exceeds the table or column limit, connect to a specific schema instead of the whole database — you can scope the connection during datafrey db connect.
Direct run calls (SQL execution without planning) don’t consume any token budget.

​
Query execution

ConstraintValue
Max rows returned300
Statement timeout30 s
Max query length10,000 characters
Daily run requests500
The 300-row cap applies to what DataFrey returns to your AI client — the query itself runs in full in Snowflake. Query directly in Snowflake if you need the complete result set.

​
Database connection

Snowflake is the only supported database today — more are coming. For privileges, setup SQL, and auth, see Snowflake setup.
Snowflake PATs expire after 180 days. An expired PAT breaks all queries until you replace it. Regenerate the token before it expires — the Snowflake setup page has the SQL.

​
MCP server & AI clients

Claude Code

Run datafrey client claude to install the DataFrey plugin (MCP server + /db skill).

Cursor

Run datafrey client cursor to register MCP via deeplink.

Any MCP-compatible client

Run datafrey client mcp to print the JSON config, then paste it into your client’s MCP settings.

​
DataFrey login session

These limits apply to your DataFrey login session, not Snowflake credentials.
ConstraintValue
Device code window15 min to complete browser login
datafrey db connect freshnessSession must be ≤ 5 minutes old
If datafrey db connect prompts you to log in again, your session is older than 5 minutes. Complete the login flow and the connection setup resumes automatically.

​
CLI

  • Python 3.13 or later — required for all packages
  • Install with pip install datafrey or uv tool install datafrey
Auth tokens are stored in your OS secure keychain — no plain-text fallback.

macOS

macOS Keychain

Linux

GNOME Keyring or KWallet — must be installed and unlocked before you run the CLI.

Windows

Windows Credential Locker
On Linux, if no keyring daemon is running, the CLI exits with an error. Install and unlock GNOME Keyring or KWallet before using DataFrey.