How do I use Data Nexus MCP?

1. Click on "Install Server". 2. Wait a few minutes for the server to deploy. Once ready, it will show a "Started" state. 3. In the chat, type @ followed by the MCP server name and your instructions, e.g., "@Data Nexus MCP show me the schema of the users table in postgres_prod" That's it! The server will respond to your query, and you can continue using it as needed. Here is a step-by-step guide with screenshots.

de en es ja ko ru zh

Data Nexus MCP

by HumanSamadian

Overview Schema Related Servers Score Discussions

Python

Remote

Provides a driver for ArangoDB, a multi-model database, enabling querying and schema management (stub driver, extensible).

Provides a fully implemented driver for ClickHouse, a time-series database, enabling query execution and schema exploration.

Provides a stub driver for Couchbase, a document database, enabling integration and extensibility.

Provides a stub driver for Databricks, a warehousing service, enabling integration and extensibility.

Provides a fully implemented driver for DuckDB, an embedded database, enabling query execution and schema management.

Provides a fully implemented driver for Elasticsearch, a search engine, enabling query execution and schema exploration.

Provides a stub driver for etcd, a key-value store, enabling integration and extensibility.

Provides a fully implemented driver for InfluxDB, a time-series database, enabling query execution and schema management.

Provides a fully implemented driver for Milvus, a vector database, enabling query execution and schema exploration.

Provides a fully implemented driver for MongoDB, a document database, enabling querying and collection management.

Provides a fully implemented driver for MySQL, a relational database, enabling SQL queries and schema inspection.

Provides a fully implemented driver for Neo4j, a graph database, enabling querying and schema exploration.

Provides a stub driver for Neptune, a graph database, enabling integration and extensibility.

Provides a fully implemented driver for OpenSearch, a search engine, enabling query execution and schema exploration.

Provides a fully implemented driver for PostgreSQL, a relational database, enabling SQL queries and schema inspection.

Provides a stub driver for Prometheus, a time-series database, enabling integration and extensibility.

Provides a fully implemented driver for Redis, a key-value store, enabling query execution and key management.

Provides a stub driver for RocksDB, an embedded key-value store, enabling integration and extensibility.

Provides a fully implemented driver for ScyllaDB, a wide-column database, enabling query execution and schema management.

Provides a fully implemented driver for Snowflake, a cloud data warehouse, enabling query execution and schema exploration.

Provides a stub driver for Splunk, a search engine, enabling integration and extensibility.

Provides a fully implemented driver for SQLite, an embedded database, enabling SQL queries and table management.

Provides support for TimescaleDB, a time-series relational database, enabling query execution and schema management.

Data Nexus MCP

A modular, secure platform for connecting to SQL and NoSQL databases via REST API, MCP (Model Context Protocol), and a Vue.js Web UI.

Architecture

┌─────────────┐     ┌──────────────┐     ┌─────────────────┐
│   Web UI    │────▶│  REST API    │────▶│ core-db-command │
│  (Vue.js)   │     │  (FastAPI)   │     │  (Python lib)   │
└─────────────┘     └──────┬───────┘     └────────┬────────┘
                           │                       │
                    ┌──────▼───────┐               │
                    │  MCP Server  │───────────────┘
                    └──────┬───────┘
                           │
                    ┌──────▼───────┐
                    │  MCP Client  │──▶ AI Agents / LLMs
                    └──────────────┘

Modules

Module	Package	Description
core-db-command	`core_db_command/`	Plugin-based Python library for all database drivers
rest-api-command	`rest_api_command/`	FastAPI REST layer with OAuth2/LDAP/basic auth
mcp-server	`mcp_server/`	MCP tools: `query_database`, `get_schema`, `list_tables`, `describe_table`, `execute_sql`
mcp-client	`mcp_client/`	MCP client bridge for agent integration
web-ui	`web-ui/`	Vue 3 + Pinia + Monaco Editor query studio
config	`config/`	YAML connection definitions with `${ENV}` substitution

Related MCP server: Database MCP Server

Supported Database Types

The driver registry supports 50+ database types across 13 categories:

Relational: PostgreSQL, MySQL, MSSQL, Oracle, CockroachDB, TiDB, YugabyteDB, TimescaleDB, pgvector
Document: MongoDB, DocumentDB, Firestore, Couchbase (stub)
Key-Value: Redis, DynamoDB, Memcached/etcd/RocksDB (stub)
Wide-Column: Cassandra, ScyllaDB, Bigtable/HBase (stub)
Graph: Neo4j, Neptune/JanusGraph/ArangoDB (stub)
Time-Series: InfluxDB, ClickHouse, Prometheus/QuestDB (stub)
Vector: Qdrant, Weaviate, Milvus, Pinecone
Search: Elasticsearch, OpenSearch, Splunk/Solr (stub)
Warehouse: BigQuery, Snowflake, Redshift/Databricks (stub)
Multi-Model: Cosmos DB, OrientDB (stub)
Embedded: SQLite, DuckDB, Realm/LMDB (stub)
Ledger: QLDB/BigchainDB (stub)
NewSQL: Spanner (stub)

Fully implemented drivers include PostgreSQL, MySQL, MSSQL, Oracle, MongoDB, Redis, SQLite, DuckDB, Elasticsearch, ClickHouse, Neo4j, InfluxDB, Cassandra, DynamoDB, BigQuery, Snowflake, Qdrant, Weaviate, Milvus, Pinecone, Cosmos DB, and Firestore. Stub drivers are registered and extensible.

Quick Start

Prerequisites

Python 3.11+
Node.js 20+ (for Web UI development)
Docker & Docker Compose (optional)

1. Install Python dependencies

cp .env.example .env
pip install -e ".[dev]"

2. Configure connections

Edit config/connections.yaml and set secrets via environment variables:

connections:
  - name: postgres_prod
    type: postgresql
    host: localhost
    port: 5432
    database: mydb
    user: readonly_user
    password: ${PG_PASSWORD}

3. Start the REST API

db-rest-api
# or: uvicorn rest_api_command.app:app --reload

API docs: http://localhost:8000/docs

4. Start the Web UI (development)

cd web-ui
cp .env.example .env
npm install
npm run dev

Open http://localhost:5173 — default credentials: admin / changeme

5. Run with Docker Compose

docker compose up -d

Services:

REST API: http://localhost:8000
Web UI: http://localhost:5173
PostgreSQL, MySQL, MongoDB, Redis, Elasticsearch

REST API Endpoints

Method	Path	Description
GET	`/api/connections`	List connections (no credentials)
POST	`/api/db/{name}/query`	Parameterized query
POST	`/api/db/{name}/sql`	Raw SQL / native command
GET	`/api/db/{name}/schema`	Database schema
GET	`/api/db/{name}/tables`	List tables/collections
GET	`/api/db/{name}/tables/{table}/describe`	Table structure
GET/POST	`/api/query-history`	Query history

MCP Server

Configure in .env or Cursor MCP env:

MCP_REST_API_URL=http://localhost:8000
# Option A: bearer token (when REST_API_AUTH_MODE=oauth2)
MCP_REST_API_TOKEN=<jwt-from-/api/auth/token>
# Option B: username/password (works with basic auth; auto-fetches JWT if oauth2)
MCP_REST_API_USER=admin
MCP_REST_API_PASSWORD=changeme

Run:

db-mcp-server

Add to Cursor/Claude MCP config:

{
  "mcpServers": {
    "data-nexus-mcp": {
      "command": "db-mcp-server",
      "cwd": "/path/to/data_nexus_mcp",
      "env": {
        "MCP_REST_API_URL": "http://localhost:8000",
        "MCP_REST_API_USER": "admin",
        "MCP_REST_API_PASSWORD": "changeme"
      }
    }
  }
}

Note: REST_API_* variables belong on the REST API process (db-rest-api), not in the MCP server config.

MCP Client

db-mcp-client                    # list available tools
db-mcp-client query local_sqlite "SELECT 1"

Authentication

Set REST_API_AUTH_MODE to one of:

basic — HTTP Basic Auth (default for development)
oauth2 — JWT bearer tokens via /api/auth/token
ldap — LDAP bind (requires REST_API_LDAP_SERVER and REST_API_LDAP_BASE_DN)

Adding a New Driver

Create core_db_command/drivers/mydb.py
Subclass BaseDriver and set driver_type
Decorate with @DriverRegistry.register
Import in core_db_command/drivers/registry_loader.py

from core_db_command.base import BaseDriver, DriverRegistry

@DriverRegistry.register
class MyDBDriver(BaseDriver):
    driver_type = "mydb"

    async def connect(self): ...
    async def disconnect(self): ...
    async def query(self, query, params=None): ...
    async def execute(self, command, params=None): ...
    async def list_tables(self, schema=None): ...
    async def describe_table(self, table, schema=None): ...

Testing

pytest tests/ -v

Security Notes

Credentials are never returned by the REST API or MCP server
Secrets must use ${ENV_VAR} placeholders in YAML config
All API endpoints require authentication
Query input is validated and length-limited

Project Structure

data-nexus-mcp/
├── core_db_command/       # Core library + drivers
├── rest_api_command/      # FastAPI REST API
├── mcp_server/            # MCP server
├── mcp_client/            # MCP client
├── web-ui/                # Vue.js frontend
├── config/                # YAML connection config
├── tests/                 # Unit tests
├── docker-compose.yml
├── Dockerfile
└── pyproject.toml

License

MIT

Install Server

license - permissive license

quality

maintenance

How are these scores calculated?

Maintenance

–Maintainers

–Response time

–Release cycle

–Releases (12mo)

Commit activity

Resources

GitHub Repository

Need Help?

Related Servers

Unclaimed servers have limited discoverability.

Looking for Admin?

If you are the server author, to access and configure the admin panel.

Tools

Related MCP Servers

MCP Databases Server
Databases RAG Systems Data Platforms
fean-developer
F
license
-
quality
C
maintenance
Enables LLMs and agents to interact with relational databases (SQL Server, MySQL, PostgreSQL) through MCP tools. Supports executing queries, inserting records, listing tables, and exposing database schemas with secure credential management.
Updated 10 months ago (2025-10-28 12:11 UTC)
Database MCP Server
Databases Developer Tools RAG Systems
ZeaoZhang
A
license
-
quality
D
maintenance
Provides universal database operations for AI assistants through MCP, supporting 40+ databases including PostgreSQL, MySQL, MongoDB, Redis, and SQLite with built-in introspection tools for schema exploration.
Updated 8 months ago (2025-12-08 01:59 UTC)
29
MIT
Alma Atlas
Databases Data Platforms Knowledge & Memory
velum-labs
A
license
-
quality
C
maintenance
Enables AI agents to query live schema, lineage, and query-context across data warehouses, dbt projects, orchestration systems, and BI tools via MCP tools.
Updated 4 months ago (2026-04-27 22:42 UTC)
Apache 2.0
aifordatabase-mcp
Databases Search
dann26parr69
A
license
A
quality
C
maintenance
Give your AI agent safe, plain-English access to any database via MCP. Ask questions in natural language, get SQL queries and results, run read-only queries, and set up scheduled alerts.
Updated a month ago (2026-07-07 13:00 UTC)
9
60
MIT

View all related MCP servers

Related MCP Connectors

ToolAPI
Free public MCP for AI agents — 193 tools, 44 workflows. No API key.
nlqdb — analytical memory for AI agents
Analytical memory for AI agents: a real Postgres queried in plain English over MCP. One command.
XMemo
Shared, governed long-term memory for AI agents across tools and sessions via MCP and REST.

View all MCP Connectors

Latest Blog Posts

Who's Calling? MCP Hosts Are an Identity Blind Spot (And the Spec Knows It)
By Om-Shree-0709 on July 25, 2026.
mcp
Agent Identity
OAuth 2.1
Your AI Chatbot Just Exposed Your CEO's Salary to an Intern
By Om-Shree-0709 on July 2, 2026.
Agent Identity
MCP Security
OAuth Delegation
Why MCP Servers Need Execution Sandboxing (And Why Your Current Stack Isn't Enough)
By Om-Shree-0709 on June 30, 2026.
Agentic Ai
Prompt Injection
WebAssembly

MCP directory API

We provide all the information about MCP servers via our MCP API.

curl -X GET 'https://glama.ai/api/mcp/v1/servers/HumanSamadian/data-nexus-mcp'

If you have feedback or need assistance with the MCP directory API, please join our Discord server

Data Nexus MCP

Architecture

Modules

Supported Database Types

Quick Start

Prerequisites

1. Install Python dependencies

2. Configure connections

3. Start the REST API

4. Start the Web UI (development)

5. Run with Docker Compose

REST API Endpoints

MCP Server

MCP Client

Authentication

Adding a New Driver

Testing

Security Notes

Project Structure

License

Maintenance

Resources

Looking for Admin?

Tools

Related MCP Servers

MCP Databases Server

Database MCP Server

Alma Atlas

aifordatabase-mcp

Related MCP Connectors

Latest Blog Posts

MCP directory API