Kinetica FAQs

Question 1

What is the Kinetica MCP Server?

Accepted Answer

The Kinetica Model Context Protocol (MCP) server is a software tool that exposes resources for interacting with Kinetica's database, managing SQL-GPT contexts, and enabling real-time data monitoring.

Question 2

What core features does the Kinetica MCP Server offer?

Accepted Answer

It provides functionalities such as listing database objects (tables, views, schemas), retrieving table metadata, executing read-only SQL queries, inserting JSON records into tables, and starting real-time monitoring for data changes (inserts, updates, deletes).

Question 3

How can I install the Kinetica MCP Server?

Accepted Answer

You can install it using Python's PIP (`pip3 install mcp-kinetica`) or UV (`uv add mcp-kinetica`). It requires Python 3.10 and Node.js 18.

Question 4

Does Kinetica MCP Server support real-time data monitoring?

Accepted Answer

Yes, a key feature is `start_table_monitor(table_name)`, which allows you to set up real-time monitoring for inserts, updates, and deletes occurring on a specified Kinetica table.

Question 5

What are SQL-GPT contexts in Kinetica MCP Server?

Accepted Answer

SQL-GPT contexts (`sql-context://{context_name}`) provide a structured view of a SQL-GPT context, including table names, descriptions, semantic rules, and column comments, aiding in intelligent database interactions.

Kinetica

Kinetica

Key Features

Use Cases

Key Features

Use Cases