mcpbeat

Update Keyword Engine Lists

clickhouse/update-keyword-engine-lists

Update ALLOWED_KEYWORD_ALIASES in ClickHouseSqlUtils.java and ENGINE_TO_TABLE_TYPE in DatabaseMetaDataImpl.java from failing test output. Use when StatementSQLTest.testAllowedKeywordAliasesMatchSystemKeywords or DatabaseMetaDataTest.testAllTableEnginesFromSystemTableEnginesAreMapped fails.

459 tokens
context cost
the whole folder, loaded on every use
1
files
instructions only
0
copies elsewhere
how many repositories repackaged it
1610
stars on the repo
on the repository, not the skill itself

Install

one command, takes just this skill from the repository 
npx skills add https://github.com/ClickHouse/clickhouse-java --skill update-keyword-engine-lists

The instruction itself

4 sections, as written by the author

Update keyword and engine lists from test failures

Files

Keywords:

jdbc-v2/src/main/java/com/clickhouse/jdbc/internal/parser/javacc/ClickHouseSqlUtils.java

— initAllowedKeywordAliases(), append after the last // Appended comment block.

Engines:

jdbc-v2/src/main/java/com/clickhouse/jdbc/metadata/DatabaseMetaDataImpl.java

— ENGINE_TO_TABLE_TYPE static block, insert a new group before // Special.

Steps

  • Parse the failing test message to extract the list of missing items.
  • For keywords (StatementSQLTest failure — e.g. ["CURSOR", "DETERMINISTIC", ...]):

Append a new dated comment + entries at the end of buildKeywordSet(...), after the last existing // Appended block:

   // Appended MM/DD/YYYY
   "KEYWORD1", "KEYWORD2", ...

The previous entry must have a trailing comma. Keep alphabetical order within the new block.

  • For engines (DatabaseMetaDataTest failure — e.g. [Paimon, PaimonAzure, ...]):

Add a new named group before // Special in the static block:

   // <GroupName> (appended MM/DD/YYYY)
   map.put("Engine1", TableType.REMOTE_TABLE.getTypeName());

Choose TableType by analogy:

  • External storage (S3/Azure/HDFS variants, lake formats) → REMOTE_TABLE
  • MergeTree family or local engines → TABLE

Output

After editing, output this git commit command:

git commit -m "jdbc-v2: update <keywords|engines|keywords and engines> in JDBC"

How to use it

Copy the folder

Take clickhouse/update-keyword-engine-lists from the repository into ~/.claude/skills for personal use, or into .claude/skills inside a project.

Check the name does not clash

The agent identifies a skill by the name field in its header. Two skills with the same name cannot sit side by side — one of them will be ignored.