kinetica-query

Guide Kinetica SQL query writing for geospatial, time-series, and vector functions.

4|1|Updated Feb 26, 2026
One-click install
npx skills add https://github.com/kineticadb/agent-skills --skill kinetica-query
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: kinetica-query
Source: https://github.com/kineticadb/agent-skills/tree/main/plugins/kinetica/skills/kinetica-query
Command: npx skills add https://github.com/kineticadb/agent-skills --skill kinetica-query

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

This Skill helps users write and understand complex Kinetica SQL queries, especially for advanced data types like geospatial, time-series, and vector data.

Core Features & Use Cases

  • SQL Query Assistance: Guides users in writing Kinetica-specific SQL, including geospatial, time-series, and vector functions.
  • Data Exploration: Helps users query and analyze data efficiently using Kinetica's accelerated engine.
  • Use Case: A data analyst needs to find all stores within a 5km radius of a specific point in Kinetica. This Skill can help them construct the correct STXY_DWITHIN query.

Quick Start

Use the kinetica-query skill to write a SQL query to find all records in the 'my_table' table where the 'created_at' column is within the last 7 days.

Frequently Asked Questions about kinetica-query

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I write a geospatial SQL query in Kinetica to find records within a specific radius?

To write a Kinetica geospatial SQL query, you can use functions like STXY_DWITHIN to find all records within a specified radius of a coordinate point. The skill guides you through the exact syntax for this spatial filtering.

Does Kinetica SQL support vector search and time-series data analysis?

Yes, Kinetica SQL supports vector search and time-series data analysis through advanced built-in functions. You can construct queries to process and analyze vector embeddings and time-series datasets efficiently.

How do I interact with the Kinetica REST API using curl to execute SQL queries?

You can interact with the Kinetica REST API using curl to execute SQL queries by sending HTTP requests directly. The skill provides guidance on parsing the complex JSON responses returned from these API calls.

What is the best way to query JSON and array data types using Kinetica SQL?

The best way to query JSON and array data types in Kinetica SQL is by using its advanced native functions. This skill helps you construct the correct syntax to parse and extract nested values from these complex data structures.

Can I use standard SQL for text search and graph analytics in Kinetica?

Yes, you can use Kinetica's SQL interface to perform text search and graph analytics. The skill provides the specific query writing guidance needed to leverage these advanced analytical features.

How do I filter time-series records by a relative time window in Kinetica SQL?

To filter time-series records in Kinetica SQL, you construct a query using the appropriate date and time functions to target a specific relative window. The skill offers guidance on writing these time-based filtering queries.