Back to Integrations
Custom Deploymentmujpi connectorBusiness & Developer Systems
SQL Databases
Establish secure, direct connections between MUJPI and your organization's SQL databases. This integration focuses on translating natural language into SQL queries for read-only analytics, while strictly preventing unauthorized data modification or exfiltration.
Architecture & Data Flow
A specialized agent generates SQL, which is parsed and verified for read-only safety before execution against the target database.
Natural Language Query
SQL Generation Agent
Query Sanitizer (Read-Only Check)
Database Engine
Result Set to Natural Language
Data Flow
Generated queries are executed. The resulting datasets are returned to the agent, which synthesizes a human-readable answer. Large result sets are paginated or truncated to prevent memory overload.
Typical Use Cases
- ✦Natural language business intelligence querying
- ✦Real-time inventory lookup for support agents
- ✦Financial reporting automation
- ✦Log analysis and anomaly detection
Capabilities
- ✦Natural language to SQL translation
- ✦PostgreSQL, MySQL, and SQL Server dialects
- ✦Table and column restriction mapping
- ✦Query optimization and sanitization
Security Considerations
- Database credentials must strictly be granted read-only (`SELECT`) permissions at the database level.
- MUJPI enforces secondary software-level checks to block `INSERT`, `UPDATE`, `DELETE`, or `DROP` commands.
- Sensitive columns (e.g., passwords, SSNs) should be explicitly excluded from the schema map provided to the AI.
- Queries must include strict timeout limits.
Setup & Deployment
Deployment Modes
Local network connectionCloud database connection (RDS, Azure SQL)
Setup Overview
Provide a read-only database connection string. MUJPI will introspect the schema. Select which tables and columns the agent is permitted to query.