How to use Nexus Pilot: what you can do with it

4 use cases

• Ask questions about a database in plain language

  Connect a database and get answers from its data without writing SQL by hand.

  • REPO GuqierMcl/NexusPilot
  • Data and analytics
  • Intermediate
  View prompt

  Using the NexusPilot repo at https://github.com/GuqierMcl/NexusPilot, set up a connection to <database name> and ask the agent in Ask mode: <your question>. Expected output: a written answer with the query used and the result rows. Verify that the query only reads data and that the answer matches a manual check of at least one row.

  Share Email me this

• Run a multi-step data task with approval checks

  Delegate a multi-step database task to the Agent mode and review each write before it runs.

  • REPO GuqierMcl/NexusPilot
  • Data and analytics
  • Advanced
  View prompt

  Using the NexusPilot repo at https://github.com/GuqierMcl/NexusPilot, run `bun install` and `bun run dev:all`, then give the Agent mode this task on <connection name>: <task description>. Expected output: a summary of each step and each approved write. Verify that every write was shown with a risk analysis and approved by a person before it ran.

  Share Email me this

• Inspect ClickHouse tables, projections, and indexes

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

  • REPO GuqierMcl/NexusPilot
  • Data and analytics
  • Intermediate
  View prompt

  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.

  Share Email me this

• Verify a Nexus Pilot change before a pull request

  Run the project's type, test, format, and lint checks on a change before submitting it.

  • REPO GuqierMcl/NexusPilot
  • Data and analytics
  • Advanced
  View prompt

  Using the NexusPilot repo at https://github.com/GuqierMcl/NexusPilot, run the verification commands in the README on my current change and report the result of each one. Expected output: a pass or fail line for tsc, ai-runtime tests, cargo test, cargo fmt check, and cargo clippy. Verify that no command was skipped and that any failure includes the first error message.

  Share Email me this

Quick start with Nexus Pilot

1. Check you have what it needs: 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.
2. Open GuqierMcl/NexusPilot on GitHub and read the README and license.
3. Download the installer for your platform from the official release page at https://nexuspilot.dev/releases.
4. Open Nexus Pilot and add a connection to one of the supported databases: PostgreSQL, MySQL, SQLite, Redis, ClickHouse, or Oracle.
5. Open the local AI Runtime, add a provider and model, and enter the provider credentials in the app's provider settings.
6. Open the agent in Ask or Query mode and type a data question in natural language.

These steps come from our top use case, Ask questions about a database in plain language, which also has a copy-paste agent prompt.

Using the Deduped MCP, get the setup steps for GuqierMcl/NexusPilot

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

Nexus Pilot alternatives · Best AI repos for Data and analytics

About this repo

• Who it is forDevelopers and data teams who want to explore several database engines in one app and ask questions about their data in plain language.
• Why it is hot129 stars, launched 67 days ago
• LanguageTypeScript
• Sourcegithub.com/GuqierMcl/NexusPilot · Back to Hot repos

Requirements

• 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

Related repos

• Trended earlier REPO Aisland-SJL/dsh-usage DSH Usage dsh-usage is a JavaScript plugin for DeepSeek Harness that adds a persistent balance and token-usage dock, a detail panel, an activity heatmap, and a DSH versus Claude Code usage comparison.
• Trended earlier REPO ashishsinha1602/schemagate Schemagate schemagate is a Python library and local studio page that filters a text-to-SQL schema by the caller's grants, so restricted tables never reach the LLM prompt.
• Trended earlier REPO AsoBeast/asobeast Asobeast AsoBeast is an open source App Store Optimization tool and keyword rank tracker for the Apple App Store and Google Play, self-hosted with Docker or used as a hosted service.