ai-powered database schema discovery and api generation
Automatically analyzes database schemas by connecting to the source, extracting table/column/relationship metadata, sampling data to understand content patterns, and feeding this context to an LLM (via configurable AI provider) to generate optimized API configurations. The system creates a gateway.yaml file containing REST endpoint definitions, query parameters, and filtering logic tailored to the database structure without manual API design.
Unique: Uses LLM-driven discovery workflow (schema → sampling → AI prompt → config generation) rather than static code templates, enabling context-aware API design that understands data semantics and relationships. Supports 9+ database connectors through unified interface, allowing single discovery workflow across heterogeneous data sources.
vs alternatives: Generates LLM-optimized APIs in minutes vs. weeks of manual REST API design, and supports more database types than competing API generators like PostgREST or Hasura
multi-protocol api server hosting (rest, mcp, mcp-sse)
Hosts generated API configurations as three distinct server types from a single gateway.yaml definition: REST API with OpenAPI/Swagger documentation for HTTP clients, MCP (Model Context Protocol) server for direct AI agent integration via stdio/SSE transport, and MCP-SSE (Server-Sent Events) for browser-based agent communication. Each protocol exposes the same underlying data access logic through protocol-specific serialization and transport layers.
Unique: Single gateway.yaml drives three distinct server implementations (REST, MCP stdio, MCP-SSE) without code duplication, using a unified connector/plugin architecture to handle protocol translation. MCP-SSE support enables browser-based agents without requiring separate API gateway or CORS configuration.
vs alternatives: Eliminates need to maintain separate REST and MCP implementations vs. building MCP servers alongside REST APIs; MCP-SSE support is rare in database gateway tools
configuration-driven api definition without code changes
Stores all API definitions, endpoint configurations, and server settings in a single gateway.yaml file that can be edited, versioned, and deployed independently of gateway binary. Changes to gateway.yaml (adding endpoints, modifying filters, adjusting pagination) take effect on server restart without recompilation, enabling rapid iteration and configuration management through version control.
Unique: Single gateway.yaml file drives all API definitions, server configuration, and plugin settings without requiring code changes or recompilation. Enables configuration-as-code practices and rapid iteration.
vs alternatives: More flexible than hardcoded APIs; enables rapid changes without rebuilds vs. code-based API frameworks
unified database connector abstraction with multi-database support
Implements a common connector interface that abstracts database-specific details (connection pooling, query dialects, data type mapping) for 9+ database systems including PostgreSQL, MySQL, Snowflake, BigQuery, Oracle, and ElasticSearch. Each connector handles authentication, schema introspection, query execution, and result serialization while exposing a uniform API to the gateway core, enabling single codebase to support heterogeneous data sources.
Unique: Implements connector interface pattern where each database type (PostgreSQL, Snowflake, BigQuery, etc.) is a pluggable implementation handling dialect-specific logic, schema discovery, and query execution. Unified interface allows API generation and hosting logic to remain database-agnostic while supporting 9+ distinct systems.
vs alternatives: Supports more database types than single-database tools like PostgREST; more flexible than ORMs like Sequelize that require code changes per database
plugin-based extensibility system for security and performance
Provides interceptor and wrapper-based plugin architecture allowing custom middleware to be injected into request/response pipeline without modifying core gateway code. Supports security plugins (authentication, authorization, rate limiting) and performance plugins (caching, query optimization, result transformation) as composable units that execute before/after API operations.
Unique: Uses interceptor/wrapper pattern for plugins rather than hook-based callbacks, allowing plugins to wrap entire request/response cycle and compose with other plugins. Supports both security (auth, rate limiting) and performance (caching, optimization) plugins in unified framework.
vs alternatives: More flexible than hardcoded security features; allows custom business logic without forking gateway code vs. monolithic API frameworks
openapi/swagger documentation generation from database schema
Automatically generates OpenAPI 3.0 specification from discovered database schema and generated API configuration, creating interactive Swagger UI documentation that describes all available endpoints, parameters, request/response schemas, and data types. Documentation is served alongside REST API and can be used by API clients for code generation and validation.
Unique: Generates OpenAPI specs directly from database schema and AI-generated API config rather than requiring manual annotation, enabling documentation to stay in sync with schema changes automatically.
vs alternatives: Eliminates manual OpenAPI maintenance vs. hand-written specs; more complete than basic API documentation
mcp tool schema generation and function calling integration
Converts database API endpoints into MCP tool definitions with JSON schema specifications for parameters and return types, enabling AI agents to discover and invoke database queries as native function calls. Each generated tool maps to a database operation (SELECT, INSERT, UPDATE, DELETE) with schema-validated inputs and structured outputs compatible with LLM function-calling APIs.
Unique: Automatically derives MCP tool schemas from database schema and generated API config, enabling agents to discover and call database operations without manual tool definition. Supports schema validation on inputs to prevent malformed queries.
vs alternatives: Eliminates manual MCP tool definition vs. hand-coding tools for each database operation; schema validation prevents agent errors
docker and kubernetes deployment packaging
Provides pre-built Docker images and Kubernetes manifests for containerized gateway deployment, enabling single-command deployment to cloud platforms. Includes environment variable configuration for database credentials, API keys, and server settings, allowing gateway instances to be spun up without code changes or rebuilds.
Unique: Provides pre-built Docker images and Kubernetes manifests alongside source code, enabling zero-build deployment. Environment variable configuration allows same image to serve multiple database configurations without rebuilds.
vs alternatives: Faster deployment than building from source; more flexible than static binaries for cloud environments
+3 more capabilities