ZTeraDB Features

Management Features

Operational capabilities for platform and ops teams to govern instances, schemas, and access.

Control Plane for Instances

•Register and manage database instances (self-hosted or managed) from one control surface.
•Group instances by environment (dev / qa / prod) and apply consistent policies.
•Centralized visibility and operations without touching each vendor console.

Hybrid Instance Support

•Connect self-managed Postgres, MySQL, MSSQL, Oracle and MariaDB instances.
•Operate across hybrid clouds and on-prem environments with consistent controls.
•Assign instance-level roles and rotate keys centrally.

Instance Groups & Environments

•Organize instances into groups for tenant, team or environment scoping.
•Apply group-level access policies and schema guards.
•Simplify scaling and policy rollout across many instances.

Environment Management

•Define environment-aware rules for dev, staging, and production.
•Promote schema changes safely with validation gates.
•Prevent environment drift by enforcing consistent config.

Schema Governance

•Create, share and version schemas centrally across engines.
•Schema validation and change previews before deploying to production.
•Control schema access per-team or per-tenant.

Access & Role Management

•Fine-grained RBAC with local/global scopes and environment awareness.
•Grant read/write/delete/full access scoped to instances, schemas or data.
•Audit and review role changes centrally.

Centralized Operations Dashboard

•One-pane visibility of instances, schemas, keys and recent activity.
•Quick actions for provisioning, key rotation and policy updates.
•Operational logs and audit trails for compliance.

Developer Features

Developer-focused tools and APIs to integrate ZTeraDB into your workflows.

Schema Documents (Auto-generated)

•Auto-generate human-readable schema docs on every change.
•Share stable schema snapshots with downstream teams and CI.
•Documentation can be exported or embedded in your internal portal.

ZTeraDB Drivers

•Official drivers for Node.js, PHP and Python with a consistent API.
•Transparent connection model supporting managed and self-hosted instances.
•Libraries designed for predictable behavior across engines.

REST API for Automation

•Full JSON-based REST API for schema, instance and access management.
•Integrate ZTeraDB with CI/CD, provisioning scripts and admin tooling.
•API-first design keeps automation simple and auditable.

ZQL — One Query Model

•A JSON-based, engine-agnostic query model to unify reads/writes.
•Avoid repeated SQL rewrites and reduce integration complexity.
•ZQL is designed to map cleanly to each engine’s capabilities.

Deployment & Provisioning

•APIs and UI for provisioning schemas, users and environment configs.
•Integrate deployments into your existing pipelines for zero-touch rollout.
•Rollback and promotion workflows for safe releases.

Built-in Validation

•Field-level and type validation rules enforced before write to any engine.
•Prevents common runtime errors and data inconsistencies.
•Validation rules are portable between environments.

Security & Compliance

Security capabilities built for enterprise requirements and auditability.

Transport Layer Security (TLS)

•TLS-encrypted connections between clients, ZTeraDB and database instances.
•Prevents interception and eavesdropping on management traffic.

HTTPS & API Security

•HTTPS enforced for dashboard and REST endpoints.
•Token-based auth, API key scoping and short-lived credentials.

Authentication & Permissions

•SAML / OIDC / SSO integrations for enterprise identity systems.
•Fine-grained permission model with audit trails.

XSS & Injection Protections

•Sanitization and output escaping in UI and APIs.
•Query validation to reduce injection risks across engines.

SQL Injection Defenses

•Parameterized ZQL layer and server-side checks to prevent injection.
•Engine-specific safety wrappers where direct SQL is used.

Secure Password Storage

•Strong hashing and secret management for user credentials.
•Integration with vaults for production-grade secret rotation.