skills.rest
tehnplk
tehnplkCOMMUNITY
Explore all skills by this author →
GitHub

hosxp

Query HOSxP hospital data in a MariaDB container via SQL.

Updated Feb 20, 2026
Search Tags:#database#sql#patient data#public health#hosxp#hospital information system
One-click install
npx skills add https://github.com/tehnplk/data_transform --skill hosxp
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: hosxp
Source: https://github.com/tehnplk/data_transform/tree/main/.windsurf/skills/hosxp
Command: npx skills add https://github.com/tehnplk/data_transform --skill hosxp

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This Skill provides direct access to query and analyze data within a HOSxP Hospital Information System database, enabling efficient retrieval of patient information, public health statistics, and operational reports.

Core Features & Use Cases

  • Database Querying: Execute SQL queries against a MariaDB instance hosting HOSxP data.
  • Data Analysis: Generate reports on patient demographics, disease prevalence, and treatment outcomes.
  • Use Case: Retrieve a count of patients diagnosed with respiratory illnesses in the year 2568 (Thai Buddhist Era) by running a specific SQL query.

Quick Start

Use the hosxp skill to count the number of patients with respiratory diseases in the year 2568.

Frequently Asked Questions about hosxp

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

FAQPage Schema
How do I query patient data from a HOSxP database?▼

You can query HOSxP patient data by executing direct SQL statements against a MariaDB container to retrieve records, analyze OPD/IPD data, and generate public health reports.

Can I analyze OPD and IPD data using SQL?▼

Yes, you can analyze OPD and IPD data by executing SQL queries against the HOSxP MariaDB instance to generate reports on patient demographics, disease prevalence, and treatment outcomes.

Does this tool support generating public health reports?▼

Yes, generating public health reports is supported by executing SQL queries against the HOSxP database to aggregate population statistics, disease prevalence, and treatment outcomes.

How do I count patients diagnosed with specific illnesses in a given year?▼

You count patients diagnosed with specific illnesses by running targeted SQL queries against the HOSxP MariaDB database to filter and aggregate diagnostic records by year.

Do I need specific database credentials to access the hospital information system?▼

Yes, accessing the hospital information system requires specific database credentials and a configured character set to execute SQL queries directly against the 'hos11253' MariaDB instance.

What are the limitations of querying HOSxP data directly?▼

Querying HOSxP data directly is limited to the structures within the 'hos11253' MariaDB database and requires SQL knowledge to retrieve accurate patient records and statistics without compromising system integrity.

Related Skills

Explore More Data & Analytics Skills→
xiaoyuge886xiaoyuge886
196

whodb

Explore schemas, inspect tables, and execute SQL queries across multiple database engines.

Community
Intermediate
rafaelminatto1rafaelminatto1

fisioflow-analytics-dashboard

Build analytics dashboards for FisioFlow using existing BI infrastructure.

Community
Advanced
sandmark78sandmark78

data-analyst

Analyze raw data with SQL and Python to generate business insights.

Community
Advanced
2nth-ai2nth-ai
1

South African Healthcare Landscape

Analyze South Africa's healthcare system structure, regulation, and NHI policy.

Official
Intermediate