G8Connect G8Connect

Data Source to API in Minutes

Connect any database or file, introspect the schema, and auto-generate OpenAPI specs. Every spec goes through G8Stack governance before deployment.

Supported Data Sources

PostgreSQL
PostgreSQL
MySQL
MySQL
MSSQL
MSSQL
Oracle
Oracle
SQLite
SQLite
CSV
CSV
JSON
JSON
Excel
Excel
How It Works

From Data Source to Governed API

Six steps from connection to deployment. You generate — G8Stack governs.

1

Connect

Add your data source — PostgreSQL, MySQL, MSSQL, SQLite, or upload CSV/JSON/Excel files.

2

Introspect

G8Connect reads your schema automatically — tables, columns, data types, all detected.

3

Configure

Pick fields, choose HTTP methods, set filters — or let Simple Mode auto-configure everything.

4

PII Detection

Sensitive columns flagged automatically — passwords, IC numbers, bank details excluded by default.

5

Generate Spec

OpenAPI 3.1 spec generated instantly. Review it, version it, refine it before submission.

6

Push to G8Stack

Submit to G8Stack for governance approval. Only approved specs deploy to Kong Gateway.

Wizard Modes

Three Modes, One Output

Whether you're a non-technical user or a data scientist, G8Connect adapts to your workflow.

Easiest

Simple Mode

For non-technical users

  • Pick a table
  • Auto-generate full CRUD spec
  • Zero configuration needed
  • PII auto-excluded
Most Popular

Guided Mode

For backend developers

  • Choose fields to expose or exclude
  • Select HTTP methods per endpoint
  • Configure filters and pagination
  • Rename fields for API consumers
  • Preview with sample data
Power Users

Advanced Mode

For data scientists

  • Write custom SELECT queries
  • JOINs, CTEs, aggregations
  • Named GET endpoints
  • Parameter binding to query params
  • Read-only, sandboxed execution
Security

Built for Governed Environments

Security, audit trails, and compliance built in from day one.

Encrypted Credentials

All data source credentials encrypted at rest. Never logged, never exposed in error messages, never stored in plaintext.

PII Auto-Detection

Sensitive columns like NRIC, passwords, and bank details flagged automatically and excluded from specs by default.

Full Audit Trail

Every connection, introspection, and spec generation is logged. Know who accessed what, when, and why.

Read-Only Connections

Data source connections enforced as read-only at the connector level. G8Connect never writes to your databases.

Multiple Data Sources

PostgreSQL, MySQL, MSSQL, SQLite for databases. CSV, JSON, and Excel for file-based sources — all through one interface.

Spec Versioning

Every regeneration creates a new version. Compare specs, track changes, and submit only when ready.

Speed Up Creation.
Never Skip Governance.

G8Connect generates specs. G8Stack approves them. Kong deploys them. Clear separation of concerns for teams that take API governance seriously.

Use Cases

Who G8Connect Is For

G8Connect adapts to different roles and industries — from platform teams to regulated enterprises.

API Platform Teams

Accelerate API Delivery

Stop writing boilerplate. Connect data sources, generate specs, and ship APIs in minutes instead of weeks.

  • Auto-generate OpenAPI specs from any data source
  • Built-in versioning and documentation
  • Consistent API patterns across all services
  • Governance workflow before deployment
Data Engineering Teams

Expose Data Safely

Give stakeholders API access to data without compromising security or building custom endpoints.

  • File source support (CSV, JSON, Excel)
  • Automatic PII detection and exclusion
  • Read-only connections with audit trail
  • SQL mode for complex analytical queries
Technical Leadership

Govern API Exposure

Maintain control over what data gets exposed. Every spec requires approval through your governance workflow.

  • Nothing deploys without approval
  • Role-based access control (4 levels)
  • Full audit trail on every operation
  • Encrypted credentials at rest
Regulated Industries

Stay Compliant

Built-in safeguards for industries that need strict data handling — finance, healthcare, government.

  • PII auto-detection for compliance
  • Immutable spec versioning for audit
  • SQL whitelist parser blocks dangerous operations
  • Security headers enforced on all responses
Pricing

Always Open Source

The full platform is free and open source. Enterprise adds dedicated support, managed setup, and integrations.

Recommended

Open Source

Free Forever

Full-featured, self-hosted, MIT licensed. Everything you need to generate governed APIs.

  • All database & file connectors
  • All 3 wizard modes
  • OpenAPI 3.1 spec generation
  • PII detection & auto-exclusion
  • Dynamic API runtime with live CRUD
  • API key authentication & rate limiting
  • Role-based access control
  • Immutable spec versioning
  • Full audit trail
  • Community support via GitHub
Get Started

Enterprise

Custom

Dedicated support, managed setup, and deep integrations for organisations that need more.

  • Everything in Open Source
  • Dedicated setup & onboarding
  • Priority support with SLA
  • SSO / SAML / Keycloak integration
  • G8Stack governance integration
  • Kong API Gateway deployment pipeline
  • Custom connector development
  • Multi-org & tenant isolation
  • Advanced compliance & audit reports
  • On-premise deployment support
Contact Us
FAQ

Frequently Asked Questions

Everything you need to know about G8Connect.

What data sources does G8Connect support?
G8Connect supports four database types — PostgreSQL, MySQL (MariaDB compatible), Microsoft SQL Server, and SQLite. It also supports file sources including CSV, JSON, and Excel (.xlsx) with automatic type inference and multi-sheet support.
Does G8Connect deploy APIs directly?
No. G8Connect follows a governance-first architecture. It generates OpenAPI specs that must go through G8Stack's approval workflow before deployment to Kong API Gateway. This ensures nothing goes live without proper review.
How does PII detection work?
G8Connect automatically scans column names for sensitive patterns — passwords, IC numbers, SSN, credit cards, email, phone, passport, and more. Flagged columns are excluded from generated specs by default. You must explicitly opt-in to expose any PII field.
Is the SQL mode safe for production use?
Yes. The SQL whitelist parser only allows SELECT and WITH (CTE) statements, blocking 28+ dangerous keywords including INSERT, UPDATE, DELETE, DROP, and ALTER. System tables are blocked, queries timeout at 10 seconds, and results are capped at 1,000 rows — all hardcoded and non-configurable.
Is G8Connect free?
Yes, always. G8Connect is fully open source under the MIT license with all features included. The Enterprise plan adds dedicated support, managed setup, SSO integration, and G8Stack governance pipeline — but the core product is free forever.
What does the Enterprise plan include?
Enterprise provides dedicated setup and onboarding, priority support with SLA, SSO/SAML/Keycloak integration, G8Stack governance integration, Kong deployment pipeline, custom connector development, multi-org tenant isolation, and on-premise deployment support.

Ready to turn your data into APIs?

G8Connect is open source and free forever. Get started in minutes with Docker, or explore the documentation to learn more.