SYSTEM CONNECTIONS
Give agents, workflows, widgets, and APIs governed access to the data they need. Connect PostgreSQL, MySQL, SQL Server, Oracle, MariaDB, REST APIs, and internal systems with table-level, column-level, and deployment controls.
Orckai connects the apps, databases, APIs, files, and internal knowledge your company runs on, giving AI experiences structured, permission-controlled business context.
Full support for PostgreSQL 12 through 17. Orckai introspects your schema, discovers tables, views, and columns, then generates an MCP server with typed tool definitions for every table you expose. Ideal for analytics stacks, SaaS backends, and data warehouses. See the PostgreSQL MCP tutorial.
Connect to MySQL 5.7 or 8.x instances. Orckai reads your information_schema, maps column types to MCP tool parameters, and produces a server that lets AI agents query, filter, and aggregate data across your MySQL tables without writing a single SQL statement manually.
Enterprise-grade support for Microsoft SQL Server 2016 and newer, including Azure SQL. The generator handles SQL Server-specific types, schemas, and authentication modes so your AI agents can access ERP, CRM, and reporting databases through a clean MCP interface.
Oracle Database 12c and later. Orckai connects via Oracle Instant Client, introspects tablespaces and schemas, and generates MCP tools that respect Oracle's data types and naming conventions. Bring AI to your Oracle EBS, HCM, or custom Oracle workloads.
Drop-in support for MariaDB 10.x and 11.x. Because MariaDB shares MySQL's wire protocol, Orckai leverages the same schema introspection engine with MariaDB-specific optimizations for sequence types, system-versioned tables, and columnstore indexes.
Import an OpenAPI (Swagger) spec or manually define endpoints, and Orckai generates an MCP server that wraps each endpoint as a callable tool. Support for Bearer tokens, API keys, custom headers, and OAuth flows means your agents can talk to any HTTP service.
Every MCP server Orckai generates is packaged as a Docker container and deployed automatically. No Dockerfile authoring, no image registry management, no networking configuration.
Orckai generates a production-ready Docker image for each MCP server. The image includes the MCP runtime, your schema-specific tool definitions, database drivers, and health check endpoints. Build and deployment happen in the background — you never touch a Dockerfile.
Each MCP server container runs on an isolated Docker network. It can reach your database through a configured connection string but is not exposed to the public internet. Agent-to-MCP communication uses internal networking, keeping your data plane private and auditable.
Every deployed MCP server includes a built-in health endpoint that Orckai polls continuously. If a container becomes unresponsive or crashes, Orckai detects it and surfaces the status in your dashboard. You can stop, restart, or redeploy any MCP server with a single click.
Create a governed system connection for these sources. Orckai handles connection, schema introspection, tool generation, and Docker deployment automatically.
Full schema introspection across all data types including pgvector for AI-native vector search. Ideal for analytics, SaaS backends, and data warehouses.
Tables, views, and stored procedures with full CRUD support. Auto-maps column types to MCP tool parameters for type-safe agent interactions.
Windows and Azure SQL Database with integrated authentication support. Connect AI agents to ERP, CRM, and reporting databases through a clean MCP interface.
Enterprise Oracle databases with tablespace awareness and Oracle-specific type handling. Bring AI to Oracle EBS, HCM, and custom Oracle workloads.
MySQL-compatible with MariaDB-specific features including sequence types, system-versioned tables, and columnstore indexes.
Any REST API endpoint wrapped as MCP tools. Import OpenAPI specs or define endpoints manually with Bearer token, API key, and OAuth support.
System connections turn your databases and APIs into governed tools that AI agents can use. Here is how teams are using them in production.
Generate an MCP server for your production database and let agents query tables, run reports, and answer business questions in natural language. End users get answers without writing SQL or waiting for the data team.
Wrap your Salesforce or HubSpot REST API as MCP tools. Agents create leads, update opportunities, and search contacts on behalf of your sales team. Your reps get an AI assistant that actually knows your pipeline data and can take action on it.
Deploy MCP servers for your HR database, finance database, and project management API. A single agent queries all three, correlates data across systems, and delivers cross-functional insights that would normally require three different dashboards and a data engineer.
Connect to legacy databases like Oracle and SQL Server that lack modern APIs. The MCP server becomes the modern interface layer. AI agents interact with decades-old data through clean, auto-generated tools without touching the legacy system's internals.
Orckai