DataKook – Database Web Interface, REST API Builder & AI-Powered Data Access

DataKook is a universal Azure-hosted platform that simplifies data access, management, and integration.

It combines four complementary capabilities in a single secure solution deployed entirely inside your Azure environment:

1. A Database Web Interface for exploring and managing data.
2. A REST API Builder that transforms database tables into secure CRUD APIs.
3. A No-Code UI & Workflow Designer that lets business users create data management apps connected to your databases.
4. AI-Powered Data Access that brings the power of large language models to your database workflow — without exposing your data.

1. Unified Database Web Interface

A visual environment for working across multiple databases without switching tools or writing code.
- Connect instantly to PostgreSQL, SQL Server, MySQL, Oracle, or other supported databases.
- Browse schemas, tables, and relationships visually.
- Run SQL queries and preview results in real time.
- Edit and filter data securely within your Azure instance.
- Define roles and permissions per user or group.

2. REST API Builder

Automatically generates REST endpoints for all connected tables.
- Auto-generated CRUD operations.
- JWT, Azure AD, or SAML authentication.
- Built-in pagination, filtering, and sorting.
- OpenAPI/Swagger documentation available instantly.
- Per-user and per-role access control.

3. No-Code UI & Workflow Designer (Integrated MDM)

Empowers non-technical users to build business-ready applications without writing code. Turns DataKook into a Master Data Management (MDM) tool integrated with your existing databases.
- Drag-and-drop UI creation directly bound to your tables.
- Configure display as grids, forms, dropdowns, or workflows.
- Auto-generate data entry forms for each entity.
- Define approval workflows for managing data changes.
- Controlled access for business users with database-level security.

Teams can collaborate, validate, and enrich data without relying on IT or custom development.

4. AI-Powered Data Access — Secure by Design

DataKook integrates AI through a security-first architecture. The AI model has no direct access to your databases — no connection strings, no credentials, and no raw data are shared with the LLM. DataKook acts as a secure bridge, sharing only schema metadata.

- Natural Text to SQL — Generate SQL by describing what you need in plain language. The AI produces accurate, dialect-specific SQL from simple lookups to complex joins.
- AI Assistant — Corrects SQL errors, optimizes slow queries, explains complex statements, and suggests refactoring — all within DataKook's secure perimeter.
- AI REST APIs — Expose AI-powered natural language endpoints as secure REST APIs. Integrate with AI agents (LangChain, Semantic Kernel, AutoGen), chatbots, and automation pipelines.
- Business User AI — Non-technical users query databases, generate insights, and create charts using natural language. Role-based access controls ensure authorized data access only.

Supports by default Azure OpenAI. Teams can also configure their own API keys (Anthropic, OpenAI, Google Gemini, ...).

5. Azure-Native and Secure

Delivered as an Azure Managed Application, deploying:
- Azure App Service (web interface + backend APIs, )
- Azure Database for PostgreSQL (configuration & metadata)
- Azure Key Vault (secure credentials management)

Your data stays fully within your subscription — ensuring compliance with corporate and regional data protection standards.

6. Use Cases

- Centralized data administration across multiple databases
- Secure self-service data management for business teams
- Automatic API generation for application development
- AI-powered natural language querying across all connected databases
- AI agent and chatbot integration via REST APIs
- Integrated MDM and workflow solutions
- Fast prototyping for analytics and automation

7. Licensing

Available as a Microsoft-managed transactable offer. Deploy and subscribe directly through the Azure Marketplace — billing handled by Microsoft.

8. Support

📧 support@datakook.com
🌐 https://www.datakook.com