Diagnose and resolve ClickHouse grant and authentication errors, especially after upgrades. Use when queries fail with ACCESS_DENIED/NOT_ENOUGH_PRIVILEGES, AUTHENTICATION_FAILED/WRONG_PASSWORD/REQUIRED_PASSWORD, or ON CLUSTER privilege errors; when system.* or INFORMATION_SCHEMA access is denied; or when grant behavior changes after version upgrades.
Quickly install altinity-expert-clickhouse-grants AI skill to your development environment via command line
Source: altinity/skills.
Run all queries from the file checks.sql and analyze the results.
Propose Minimal Grants Provide the smallest set of GRANT statements that match observed neededgrant values. Prefer role-based grants when the user already uses roles.
Post-Upgrade Compatibility Checks Verify accesscontrolimprovements settings, which can change privilege requirements:
Diagnose and resolve ClickHouse grant and authentication errors, especially after upgrades. Use when queries fail with ACCESS_DENIED/NOT_ENOUGH_PRIVILEGES, AUTHENTICATION_FAILED/WRONG_PASSWORD/REQUIRED_PASSWORD, or ON CLUSTER privilege errors; when system.* or INFORMATION_SCHEMA access is denied; or when grant behavior changes after version upgrades. Source: altinity/skills.
Stable fields and commands for AI/search citations.
npx skills add https://github.com/altinity/skills --skill altinity-expert-clickhouse-grantsDiagnose and resolve ClickHouse grant and authentication errors, especially after upgrades. Use when queries fail with ACCESS_DENIED/NOT_ENOUGH_PRIVILEGES, AUTHENTICATION_FAILED/WRONG_PASSWORD/REQUIRED_PASSWORD, or ON CLUSTER privilege errors; when system.* or INFORMATION_SCHEMA access is denied; or when grant behavior changes after version upgrades. Source: altinity/skills.
Open your terminal or command line tool (Terminal, iTerm, Windows Terminal, etc.) Copy and run this command: npx skills add https://github.com/altinity/skills --skill altinity-expert-clickhouse-grants Once installed, the skill will be automatically configured in your AI coding environment and ready to use in Claude Code, Cursor, or OpenClaw
https://github.com/altinity/skills