Hyperterse

What is Hyperterse?

Hyperterse is a high-performance runtime server that transforms your database queries into RESTful API endpoints and MCP tools for AI agents. By defining queries in a simple configuration file, Hyperterse automatically generates endpoints, OpenAPI documentation, input validation, and AI integration materials, all without writing boilerplate code. It acts as a secure gateway that keeps raw SQL, connection strings, and internal errors contained within the runtime while exposing a production-ready API surface.

Hyperterse supports PostgreSQL, MySQL, and Redis through a unified interface, enabling database independence and a consistent development experience from prototype to multi agent systems. The goal is to provide a fast, interpretable, and portable platform where queries can be evolved rapidly with immediate feedback during development and effortless deployment to production.

Key Features

• Declarative Data Interfaces: Define the shape and intent of data access once, and let Hyperterse handle execution, validation, and exposure.
• Agent-Ready by Design: Connect data to AI agents through discoverable, callable tools without exposing SQL, schemas, or credentials.
• Zero-Boilerplate APIs: Turn queries into production-ready APIs with typed inputs, predictable outputs, and built-in documentation.
• Single Source of Truth: Generate endpoints, OpenAPI specs, LLM-readable docs, and MCP tools from one configuration file.
• Security as a Baseline: Keep raw SQL, connection strings, and internal errors fully contained within the runtime.
• Database Independence: Work across PostgreSQL, MySQL, and Redis using a consistent, unified interface.
• Fast Iteration: Update queries and schemas with immediate feedback during development.
• Portable Deployment: Ship a self-contained runtime that moves cleanly from local development to production.

How to Use Hyperterse

1. Install Hyperterse using common package managers:
   • curl -fsSL /install | bash
   • npm i -g hyperterse
   • bun add -g hyperterse
   • brew install hyperterse/tap/hyperterse
2. Define queries in a simple configuration file such as config.terse. Include adapters that describe database connections, the SQL statements for each query, and the input parameters with their types.
3. Run the Hyperterse runtime server. It will read your configuration and generate production ready endpoints automatically.
4. Consume the generated API surface. You can call the endpoints at POST /query/{query-name}, view OpenAPI specs at GET /docs, and access LLM integration documentation at GET /llms.txt. Hyperterse also generates MCP compatible tools for AI agents.
5. Iterate quickly. Update your queries or schemas in the configuration and see immediate feedback in the running server.

Use Cases

• AI agent data access: Safe, structured access to production data for autonomous agents and decision making.
• Rapid API gateways: Turn database queries into ready to use REST APIs with strong typing and documentation.
• Multi agent systems: Provide consistent, discoverable tools for multiple agents without exposing internal schemas.
• Prototyping and experimentation: Quickly validate ideas with a high performance runtime before committing to code-heavy architectures.
• Data governance and security focused apps: Keep raw credentials and SQL hidden behind a secure runtime layer.

FAQ

What is Hyperterse? Hyperterse is a high-performance runtime server that transforms your database queries into RESTful API endpoints and MCP (Model Context Protocol) tools. Define queries in a simple configuration file, and Hyperterse automatically generates individual endpoints with full OpenAPI documentation, input validation, and AI integration.

Is Hyperterse free? Yes. Hyperterse is free and open source. You can self-host it on your own infrastructure at no cost. If you need enterprise support, reach out for assistance.

How do I define queries? Queries are defined in a simple configuration file, such as config.terse. You specify adapters (database connections), queries with SQL statements, and input parameters with their types. Hyperterse handles the rest—generating endpoints at POST /query/{query-name}, validating inputs, and creating documentation.

Which databases are supported? Hyperterse supports PostgreSQL, MySQL, and Redis out of the box. Each database has its own connector, and you can configure multiple database connections in a single Hyperterse instance.

Is Hyperterse an ORM? No. Hyperterse does not abstract away SQL. You write raw SQL queries directly in your configuration file. It focuses on query execution and API exposure, not on database abstraction or migrations. It is ideal for AI and LLM applications, API gateways, microservices, and rapid prototyping.