AgenticNexus DB

A full-stack, multi-tenant SaaS application for autonomous database management and visualization.

Features

• Multi-Database Support: PostgreSQL, MySQL, MongoDB (Atlas), SQL Server
• AI-Powered Agent: LangChain + Ollama (Llama 3) for autonomous operations
• Migration Tool: Cloud-to-cloud data migrations with validation
• Integrity Checker: Cross-database orphan detection
• Visual EER Diagrams: Interactive schema visualization with React Flow
• SQL Guardrails: HITL approval for destructive operations
• Enterprise Audit Trail: Complete compliance logging

Quick Start

Prerequisites

• Docker & Docker Compose
• Node.js 20+ (for local frontend development)
• Python 3.11+ (for local backend development)

Launch with Docker

# Clone and navigate to project
cd DBmanager

# Copy environment configuration
cp .env.example .env

# Launch all services
docker-compose up --build

Access Points

Service	URL
Frontend	http://localhost:5173
Backend API	http://localhost:8000
API Docs	http://localhost:8000/docs
Grafana	http://localhost:3000
Prometheus	http://localhost:9090

Architecture

DBmanager/
├── backend/                 # FastAPI Python backend
│   ├── app/
│   │   ├── api/v1/         # REST endpoints
│   │   ├── agents/         # LangChain tools & orchestrator
│   │   ├── core/           # Config & security
│   │   ├── db/models/      # SQLAlchemy models
│   │   └── services/       # Business logic
│   ├── Dockerfile
│   └── requirements.txt
├── frontend/               # React/Vite/TypeScript frontend
│   ├── src/
│   │   ├── components/     # React components
│   │   ├── pages/          # Page views
│   │   ├── services/       # API client
│   │   └── hooks/          # State management
│   ├── Dockerfile
│   └── package.json
├── monitoring/             # Observability
│   ├── prometheus.yml
│   └── grafana/
├── docker-compose.yml
└── .env.example

Database Tools

Tool	Description
PostgresTool	Query/manage PostgreSQL databases
MySQLTool	Query/manage MySQL databases
MongoDBTool	MongoDB/Atlas operations
SQLServerTool	SQL Server connectivity
SchemaAnalyzerTool	Extract table metadata
JSONNormalizerTool	Convert JSON to SQL DDL
MigrationTool	Cloud-to-cloud migrations
IntegrityCheckerTool	Cross-DB orphan detection

SQL Guardrails

The following patterns require Human-in-the-Loop (HITL) approval:

• DROP TABLE/DATABASE/SCHEMA
• TRUNCATE
• DELETE without WHERE clause
• UPDATE without WHERE clause

Development

Backend

cd backend
pip install -r requirements.txt
uvicorn app.main:app --reload --host 0.0.0.0 --port 8000

Frontend

cd frontend
npm install
npm run dev

Environment Variables

Variable	Description	Default
POSTGRES_USER	Control plane DB user	agenticnexus
POSTGRES_PASSWORD	Control plane DB password	agenticnexus_secret
SECRET_KEY	JWT signing key	-
ENCRYPTION_KEY	Connection string encryption	-
OLLAMA_BASE_URL	Ollama API endpoint	http://ollama:11434

License

MIT License - See LICENSE file for details.