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

How to ask questions about a database in plain language with Nexus Pilot

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

Credentials. Database connection details and LLM provider credentials are sensitive, so use a read-only database user where possible and do not paste credentials into shared chats or screenshots.

Who it is forAn analyst or developer who needs a quick answer from a live PostgreSQL, MySQL, SQLite, or ClickHouse database and does not want to write every query manually.

The problemWriting and checking queries by hand for each new data question is slow, especially when the schema is unfamiliar.

The outcomeYou get query results and explanations for plain-language questions, while the agent works through the connection you set up in the workbench.

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 the official release page at https://nexuspilot.dev/releases.
  2. Open Nexus Pilot and add a connection to one of the supported databases: PostgreSQL, MySQL, SQLite, Redis, ClickHouse, or Oracle.
  3. Open the local AI Runtime, add a provider and model, and enter the provider credentials in the app's provider settings.
  4. Open the agent in Ask or Query mode and type a data question in natural language.
  5. Read the query the agent ran and the returned rows before you rely on the answer.

Prompt for your agent

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.

Caveat. The README states that exact capabilities depend on the engine, server version, connection permissions, and runtime capability model, so some questions may not be supported for every source.

Use this in your AI agent

Ask your agent

Using the Deduped MCP, get the setup steps for GuqierMcl/NexusPilot and "Ask questions about a database in plain language"

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