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.