Ekaya

Supercharge
Product Development and Data Engineering

with Ekaya MCP to Database

Leverage Ekaya's MCP Server from your existing development tools such as Claude Code, VS Code, and Cursor. Have intelligence database access for developing business logic, writing ETL processes or analyzing the database.

Complete Developer Toolkit

Ekaya provides 13 MCP tools for AI agents, REST APIs, Arrow Flight SQL interface, Python SDKs, and comprehensive developer documentation. Everything you need to build custom integrations, extend functionality, or integrate with your existing tools.

REST APIs
Standard interfaces
Arrow Flight SQL
High performance
Python SDKs
Native integration
13 MCP Tools
For AI Agents

1Create your project

Database Selection Screen

2Import your schema

Quick Setup

Only import the tables and columns you want to bring into the ontology with minimal effort required to get going. You can always add more later.

Features:

  • Remove PII or other sensitive information
  • Control what the AI knows about and doesn't know about
Create Project and Schema Selection

3Ekaya Co-creates Your Semantic Ontology

Ontology Builder

Intelligent Data Understanding

Ekaya automatically analyzes your database schema and creates a semantic layer that bridges technical structure with business meaning.

What Ekaya Does:

  • Uses a conversational interface to ask questions and find nuance in your data
  • Maps database tables to business entities automatically
  • Identifies relationships and hierarchies in your data
  • Creates business-friendly naming conventions

Time Saved: What typically takes weeks of manual mapping is completed in minutes with AI assistance.

4Optionally add Pre-approved Queries

Governance & Control

Getting asked to provide the same reports over and over again? Ekaya can help you create pre-approved queries.

Query Builder Interface

Query Types You Can Create:

  • Standard reports and dashboards
  • Parameterized queries with variables
  • Complex joins and aggregations

Governance Features:

  • Row-level security policies
  • Data masking and PII protection
  • Audit logging and compliance tracking

Best Practice: Start with common queries your team needs daily, then expand based on usage patterns and feedback.

5Install the MCP Endpoint in Your AI Chat

Streamable HTTPS MCP

Connect to any AI chat client using Ekaya's streamable HTTPS MCP servers. No client installation required - just add the URL to your AI configuration.

MCP Server Benefits:

  • No client installation - works with any MCP-compatible AI
  • Streamable HTTPS for real-time data access
  • Regional endpoints for optimal performance
  • Global endpoint to select project at authentication time
{
  "mcpServers": {
    "ekaya": {
      "url": "https://data.ekaya.ai/mcp"
    }
  }
}

You're Live! Once you are set up, your team can now access data insights through natural conversation, with all the security and governance you've configured.