claudemods
中文English

Modsclickhouse-best-practices

clickhouse-best-practices 0.3.0 Immutable snapshotLatest

Pinned to commit 356a8c1b9a7392adb389a132f5ad3fec38532a03, captured .

Download 0.3.0 source archive Compare with previous revision 0.3.0 (2f6ec4b) View commit on GitHub

More actions and subscriptions

Choose something to compare with All versions

Current package description (not historical)

28 best practice rules for ClickHouse schema design, query optimization, and data ingestion — prioritized by impact

Install

This version is listed in the verified marketplace clickhouse-agent-skills (repository ClickHouse/agent-skills). Run these in Claude Code, in order:

  1. Add the marketplace/plugin marketplace add ClickHouse/agent-skills
  2. Install the plugin/plugin install clickhouse-best-practices@clickhouse-agent-skills

These commands install the marketplace's current upstream state, not the pinned commit snapshot on this page; the two can differ.

Contents 11

Skill11
Dependencies, compatibility and skill declarations

Recorded dependencies 0

No dependency requirements were recorded from plugin.json or marketplace entries. Only manifest fields saved with the snapshot are shown here; dependency declarations in other files are outside the current collection scope.

Recorded compatibility

No compatibility requirement was recorded for this snapshot from plugin.json or a marketplace entry. Only manifest fields saved with the snapshot are shown here. Declarations in a skill's SKILL.md header are collected separately and, when present, shown on their own under “Skill file declarations”; they never overwrite or fill in this value.

Skill file declarations 11

The content below was read separately from the header of each skill file (SKILL.md) at its pinned commit. It is text the file declares about itself, shown as an annotation only. It is stored apart from the snapshot's dependencies and compatibility (manifest fields) above and does not overwrite them. It is not the package license, version, install count or a release record, and none of it is verified.

Evidence scope and limits
  • Each entry is one file at one pinned commit, and field states hold for that file only. Components that point to the same file are merged into one entry; files with identical content share one extraction.
  • “Declared in file” means the file's header has the field. “Not declared in this file” appears only when the header parsed successfully and lacks the field. “Invalid declaration” means the field is present but its type, length or characters do not meet the requirements; it is never rewritten or truncated. “Not read” means no usable header was obtained (not yet read, read failed, no header, or an unparseable header), which says neither that the field was declared nor that it was not.
  • Compatibility and license text are the file's own wording. They do not show that anything runs, are not legal advice, and are not a license verification. metadata.version is only an annotation inside the file; it is not the package version and is not used to judge which is newer.
  • This list groups the version's skill components by their recorded source. A listed source may still be unpinned, unread or unavailable; each entry shows its state. Collection runs in bounded batches and does not promise complete coverage.
  • A file whose read failed shows a “retry eligible” time. It is only when the collector may try again, not a schedule, and it does not promise a read or completion.

1–11 of 11 skill file sources · As of

  1. skills/chdb-datastore/SKILL.md

    Header parsed

    Components using this file 1

    • chdb-datastore skills/chdb-datastore/SKILL.md

    Fields declared in the file

    Compatibility (declared in file)
    Declared in fileRequires Python 3.9+, macOS or Linux. pip install chdb.
    License text (declared in file, unverified)
    Declared in fileApache-2.0
    metadata.version (file annotation)
    Declared in file4.1
    Repository
    clickhouse/agent-skills
    Pinned commit
    356a8c1b9a7392adb389a132f5ad3fec38532a03
    File identity
    Regular-file identity recorded
    Blob SHA
    1b0958f432e9c1972ec86ec3da36bdd78d108e1b
    Mode
    100644
    Identity recorded
    Header parse
    Header parsed

    Extraction record

    First extracted by extractor version 1.

    First read from
    The same file as above.

  2. skills/chdb-sql/SKILL.md

    Header parsed

    Components using this file 1

    • chdb-sql skills/chdb-sql/SKILL.md

    Fields declared in the file

    Compatibility (declared in file)
    Declared in fileRequires Python 3.9+, macOS or Linux. pip install chdb.
    License text (declared in file, unverified)
    Declared in fileApache-2.0
    metadata.version (file annotation)
    Declared in file4.1
    Repository
    clickhouse/agent-skills
    Pinned commit
    356a8c1b9a7392adb389a132f5ad3fec38532a03
    File identity
    Regular-file identity recorded
    Blob SHA
    efe39d7cc8f8164a419cb2c93595f423b8e75aa2
    Mode
    100644
    Identity recorded
    Header parse
    Header parsed

    Extraction record

    First extracted by extractor version 1.

    First read from
    The same file as above.

  3. skills/clickhouse-architecture-advisor/SKILL.md

    Not read

    Components using this file 1

    • clickhouse-architecture-advisor skills/clickhouse-architecture-advisor/SKILL.md

    Fields declared in the file

    Compatibility (declared in file)
    Not readNo usable header, which says neither that it was declared nor that it was not.
    License text (declared in file, unverified)
    Not readNo usable header, which says neither that it was declared nor that it was not.
    metadata.version (file annotation)
    Not readNo usable header, which says neither that it was declared nor that it was not.

    This file has no usable extraction record yet, so all three fields show as “Not read”.

    Repository
    clickhouse/agent-skills
    Pinned commit
    356a8c1b9a7392adb389a132f5ad3fec38532a03
    File identity
    Regular-file identity recorded
    Blob SHA
    c8516f71253cb81f7d58aab12885ac6ebd23727c
    Mode
    100644
    Identity recorded
    Header parse
    Not read
    Why not read
    The file identity is recorded, but its content has not been read yet. declaration_unread

    No extraction record yet.

  4. skills/clickhouse-best-practices/SKILL.md

    Not read

    Components using this file 1

    • clickhouse-best-practices skills/clickhouse-best-practices/SKILL.md

    Fields declared in the file

    Compatibility (declared in file)
    Not readNo usable header, which says neither that it was declared nor that it was not.
    License text (declared in file, unverified)
    Not readNo usable header, which says neither that it was declared nor that it was not.
    metadata.version (file annotation)
    Not readNo usable header, which says neither that it was declared nor that it was not.

    This file has no usable extraction record yet, so all three fields show as “Not read”.

    Repository
    clickhouse/agent-skills
    Pinned commit
    356a8c1b9a7392adb389a132f5ad3fec38532a03
    File identity
    Regular-file identity recorded
    Blob SHA
    ba9c04d8f37cc143f05c0f28ee83c08b38d229cc
    Mode
    100644
    Identity recorded
    Header parse
    Not read
    Why not read
    The file identity is recorded, but its content has not been read yet. declaration_unread

    No extraction record yet.

  5. skills/clickhouse-js-node-coding/SKILL.md

    Not read

    Components using this file 1

    • clickhouse-js-node-coding skills/clickhouse-js-node-coding/SKILL.md

    Fields declared in the file

    Compatibility (declared in file)
    Not readNo usable header, which says neither that it was declared nor that it was not.
    License text (declared in file, unverified)
    Not readNo usable header, which says neither that it was declared nor that it was not.
    metadata.version (file annotation)
    Not readNo usable header, which says neither that it was declared nor that it was not.

    This file has no usable extraction record yet, so all three fields show as “Not read”.

    Repository
    clickhouse/agent-skills
    Pinned commit
    356a8c1b9a7392adb389a132f5ad3fec38532a03
    File identity
    Regular-file identity recorded
    Blob SHA
    6429830f784e6973564d16c31c65dbc1e1412aa9
    Mode
    100644
    Identity recorded
    Header parse
    Not read
    Why not read
    The file identity is recorded, but its content has not been read yet. declaration_unread

    No extraction record yet.

  6. skills/clickhouse-js-node-rowbinary/SKILL.md

    Not read

    Components using this file 1

    • clickhouse-js-node-rowbinary skills/clickhouse-js-node-rowbinary/SKILL.md

    Fields declared in the file

    Compatibility (declared in file)
    Not readNo usable header, which says neither that it was declared nor that it was not.
    License text (declared in file, unverified)
    Not readNo usable header, which says neither that it was declared nor that it was not.
    metadata.version (file annotation)
    Not readNo usable header, which says neither that it was declared nor that it was not.

    This file has no usable extraction record yet, so all three fields show as “Not read”.

    Repository
    clickhouse/agent-skills
    Pinned commit
    356a8c1b9a7392adb389a132f5ad3fec38532a03
    File identity
    Regular-file identity recorded
    Blob SHA
    d8cee6a2fbecbecae53a8525487a47d5c39e32c8
    Mode
    100644
    Identity recorded
    Header parse
    Not read
    Why not read
    The file identity is recorded, but its content has not been read yet. declaration_unread

    No extraction record yet.

  7. skills/clickhouse-js-node-troubleshooting/SKILL.md

    Not read

    Components using this file 1

    • clickhouse-js-node-troubleshooting skills/clickhouse-js-node-troubleshooting/SKILL.md

    Fields declared in the file

    Compatibility (declared in file)
    Not readNo usable header, which says neither that it was declared nor that it was not.
    License text (declared in file, unverified)
    Not readNo usable header, which says neither that it was declared nor that it was not.
    metadata.version (file annotation)
    Not readNo usable header, which says neither that it was declared nor that it was not.

    This file has no usable extraction record yet, so all three fields show as “Not read”.

    Repository
    clickhouse/agent-skills
    Pinned commit
    356a8c1b9a7392adb389a132f5ad3fec38532a03
    File identity
    Regular-file identity recorded
    Blob SHA
    3d3cebc8ec29c90db63a3d8f5e465dc2493ff21c
    Mode
    100644
    Identity recorded
    Header parse
    Not read
    Why not read
    The file identity is recorded, but its content has not been read yet. declaration_unread

    No extraction record yet.

  8. skills/clickhouse-managed-postgres-rca/SKILL.md

    Not read

    Components using this file 1

    • clickhouse-managed-postgres-rca skills/clickhouse-managed-postgres-rca/SKILL.md

    Fields declared in the file

    Compatibility (declared in file)
    Not readNo usable header, which says neither that it was declared nor that it was not.
    License text (declared in file, unverified)
    Not readNo usable header, which says neither that it was declared nor that it was not.
    metadata.version (file annotation)
    Not readNo usable header, which says neither that it was declared nor that it was not.

    This file has no usable extraction record yet, so all three fields show as “Not read”.

    Repository
    clickhouse/agent-skills
    Pinned commit
    356a8c1b9a7392adb389a132f5ad3fec38532a03
    File identity
    Regular-file identity recorded
    Blob SHA
    9f43e820c86ada269dbc65366e62c9ed50e2ad6b
    Mode
    100644
    Identity recorded
    Header parse
    Not read
    Why not read
    The file identity is recorded, but its content has not been read yet. declaration_unread

    No extraction record yet.

  9. skills/clickstack-otel-collector/SKILL.md

    Not read

    Components using this file 1

    • clickstack-otel-collector skills/clickstack-otel-collector/SKILL.md

    Fields declared in the file

    Compatibility (declared in file)
    Not readNo usable header, which says neither that it was declared nor that it was not.
    License text (declared in file, unverified)
    Not readNo usable header, which says neither that it was declared nor that it was not.
    metadata.version (file annotation)
    Not readNo usable header, which says neither that it was declared nor that it was not.

    This file has no usable extraction record yet, so all three fields show as “Not read”.

    Repository
    clickhouse/agent-skills
    Pinned commit
    356a8c1b9a7392adb389a132f5ad3fec38532a03
    File identity
    Regular-file identity recorded
    Blob SHA
    1cd29833d78885db29bb33ff70582aae2391c300
    Mode
    100644
    Identity recorded
    Header parse
    Not read
    Why not read
    The file identity is recorded, but its content has not been read yet. declaration_unread

    No extraction record yet.

  10. skills/infra-clickhouse/SKILL.md

    Not read

    Components using this file 1

    • infra-clickhouse skills/infra-clickhouse/SKILL.md

    Fields declared in the file

    Compatibility (declared in file)
    Not readNo usable header, which says neither that it was declared nor that it was not.
    License text (declared in file, unverified)
    Not readNo usable header, which says neither that it was declared nor that it was not.
    metadata.version (file annotation)
    Not readNo usable header, which says neither that it was declared nor that it was not.

    This file has no usable extraction record yet, so all three fields show as “Not read”.

    Repository
    clickhouse/agent-skills
    Pinned commit
    356a8c1b9a7392adb389a132f5ad3fec38532a03
    File identity
    Regular-file identity recorded
    Blob SHA
    4e6bb0b2d4f1091cbb8f32d5ba9be464cf1dab15
    Mode
    100644
    Identity recorded
    Header parse
    Not read
    Why not read
    The file identity is recorded, but its content has not been read yet. declaration_unread

    No extraction record yet.

  11. skills/infra-postgres/SKILL.md

    Not read

    Components using this file 1

    • infra-postgres skills/infra-postgres/SKILL.md

    Fields declared in the file

    Compatibility (declared in file)
    Not readNo usable header, which says neither that it was declared nor that it was not.
    License text (declared in file, unverified)
    Not readNo usable header, which says neither that it was declared nor that it was not.
    metadata.version (file annotation)
    Not readNo usable header, which says neither that it was declared nor that it was not.

    This file has no usable extraction record yet, so all three fields show as “Not read”.

    Repository
    clickhouse/agent-skills
    Pinned commit
    356a8c1b9a7392adb389a132f5ad3fec38532a03
    File identity
    Regular-file identity recorded
    Blob SHA
    31b7a8ac82516be852729663d68d89e98d81cc6e
    Mode
    100644
    Identity recorded
    Header parse
    Not read
    Why not read
    The file identity is recorded, but its content has not been read yet. declaration_unread

    No extraction record yet.

Read this page as JSON

Versions of this package2
VersionCommitCapturedComponentsActions
0.3.0 Latest Same label, several commits 356a8c1 11 View Download Diff vs previous Compare…
0.3.0 Same label, several commits 2f6ec4b 11 View Download Compare…