DEDUPED Hot AI repos, turned into use cases Get the Monday 5

How to inspect ClickHouse tables, projections, and indexes with Nexus Pilot

Browse ClickHouse databases, views, projections, and data-skipping indexes in one tree.

Who it is forA data team member who manages ClickHouse analytics tables and needs to check how objects and indexes are set up.

The problemClickHouse objects such as projections and data-skipping indexes are hard to review when you only have a generic table view.

The outcomeYou see the ClickHouse databases, tables, views, projections, and data-skipping indexes in the workbench's native object tree and can ask the agent about them.

What you need first

  • A machine that can run the NexusPilot desktop installer, or Bun 1.3 or later and a Rust toolchain for development
  • Connection details for at least one supported database that you are allowed to access
  • An API key or account with a supported LLM provider, if you want to use the AI features
  • Familiarity with the database you connect to, so you can review agent queries before acting on them

Steps

  1. Download the installer for your platform from https://nexuspilot.dev/releases and open Nexus Pilot.
  2. Add a ClickHouse connection in the connection tree.
  3. Expand the connection to open its databases and tables.
  4. Open the views, projections, and data-skipping indexes for a table to review their structure.
  5. Ask the agent in Ask mode to explain how a given table's projection or index is defined.

Prompt for your agent

Using the NexusPilot repo at https://github.com/GuqierMcl/NexusPilot, connect to a ClickHouse server at <host> and list the projections and data-skipping indexes on table <table name>. Expected output: a list of each projection and index with its definition. Verify the list against the ClickHouse server's own metadata for that table.

Caveat. The README describes native ClickHouse workflows for these objects, but it does not say every management action is available, so check what the tree allows on your server.

Use this in your AI agent

Ask your agent

Using the Deduped MCP, get the setup steps for GuqierMcl/NexusPilot and "Inspect ClickHouse tables, projections, and indexes"

Add Deduped to Claude Code once

claude mcp add --transport http deduped https://dedupedai.com/mcp

Cursor, ChatGPT, others

Share: X LinkedIn Hacker News Email Copy link

Third-party repos we don't own. AI-written use cases can be wrong. Disclaimer