semoss-database

Execute SQL queries and retrieve schema metadata for SEMOSS databases.

2|Updated Aug 6, 2025
One-click install
npx skills add https://github.com/SEMOSS/Template --skill semoss-database
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: semoss-database
Source: https://github.com/SEMOSS/Template/tree/main/.claude/skills/semoss-database
Command: npx skills add https://github.com/SEMOSS/Template --skill semoss-database

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

This skill removes the complexity of interacting with relational and graph databases on the SEMOSS platform by providing a standardized interface for executing SQL queries and retrieving schema metadata.

Core Features & Use Cases

  • Unified Querying: Execute SELECT, INSERT, UPDATE, and DELETE operations using the SqlQuery and SqlQueryBase64 commands.
  • Schema Discovery: Automatically fetch logical and physical table structures to understand database architecture.
  • Engine Management: Programmatically list and filter available databases using the MyEngines command to facilitate dynamic data source selection.

Quick Start

Use the semoss-database skill to execute a select query on the specified database engine ID and return the results.

Frequently Asked Questions about semoss-database

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

FAQPage Schema
How do I execute SQL queries on a SEMOSS database engine?

You can execute SQL queries on a SEMOSS database by using the semoss-database skill to run SELECT, INSERT, UPDATE, and DELETE operations via the SqlQuery or SqlQueryBase64 commands. It returns tabular data directly within your application.

Can I retrieve schema metadata for relational and graph databases?

Yes, you can retrieve schema metadata for relational and graph databases. The skill automatically fetches logical and physical table structures to help you discover database architecture and understand structural relationships programmatically.

How do I list available databases on the SEMOSS platform programmatically?

To list available databases on the SEMOSS platform, use the MyEngines command provided by the skill. This command programmatically lists and filters accessible database engines to facilitate dynamic data source selection.

Does database querying work within a React-based application environment?

Database querying works seamlessly within React-based applications. The skill satisfies requirements for programmatic database interaction, engine listing, and tabular data retrieval using the Semoss SDK and Pixel command language.

What is the Pixel command language used for in SEMOSS data analytics?

The Pixel command language is used to facilitate data manipulation and structural discovery in SEMOSS data analytics. It acts as the core interface for executing queries and retrieving metadata through the Semoss SDK.