skills.rest
zltastopa
zltastopaOFFICIAL
Explore all skills by this author →
WebsiteGitHub

sql-analytics

Execute 17 investigative SQL queries against CRZ contract data to detect anomalies.

3|1|Updated Mar 6, 2026
Search Tags:#analytics#data analysis#sql#procurement#contracts#anomaly detection#slovakia
One-click install
npx skills add https://github.com/zltastopa/zmluvy --skill sql-analytics-zltastopa
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: sql-analytics
Source: https://github.com/zltastopa/zmluvy/tree/main/skills/sql-analytics
Command: npx skills add https://github.com/zltastopa/zmluvy --skill sql-analytics-zltastopa

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

This Skill automates the detection of suspicious patterns and anomalies within Slovak government contract data by running a suite of pre-defined investigative SQL queries.

Core Features & Use Cases

  • Anomaly Detection: Identifies potential issues like contract splitting, threshold gaming, late publications, and hidden entities.
  • Data Analysis: Provides insights into top suppliers, money flow, and debtor cross-references.
  • Use Case: Use this skill to scan all contracts published in the last quarter for any instances of suppliers consistently splitting contracts into small amounts to avoid larger procurement thresholds.

Quick Start

Run the sql-analytics skill to scan for anomalies in CRZ contracts between January 1st and March 31st of this year.

Frequently Asked Questions about sql-analytics

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

FAQPage Schema
How do I detect contract splitting and threshold gaming in procurement data?▼

SQL anomaly detection identifies suspicious patterns like contract splitting and threshold gaming by executing 17 standard investigative queries against contract records within a specified date range.

Can I use SQL to find late publications and weekend publishing in CRZ contracts?▼

Yes, SQL queries can scan CRZ contracts to identify late publications and weekend publishing. The skill runs targeted queries to surface these specific anomalies alongside hidden entities and debtor cross-references within a specified date range.

Do I need a local SQLite database to analyze Slovak government contract anomalies?▼

You need access to a Datasette instance or a local SQLite database containing CRZ contract information. The investigative SQL queries execute directly against this stored contract data to surface suspicious patterns and anomalies.

What types of anomalies can SQL queries uncover in CRZ contract data?▼

SQL queries uncover contract splitting, threshold gaming, weekend publishing, late publication, debtor cross-references, and hidden entities. They also provide insights into top suppliers and money flow within the scanned date range.

How do I scan a specific date range for suspicious contract patterns?▼

You scan a specific date range by executing the standard investigative SQL queries against CRZ contract data bounded by your start and end dates, such as scanning all contracts published between January 1st and March 31st for anomalies.

Related Skills

Explore More Data & Analytics Skills→
zltastopazltastopa
3

crz-deep-investigate

Map Slovak company networks, government contracts, and beneficial ownership from CRZ, RPVS, FOAF, and UVO data.

Official
Advanced
Arnutt-NArnutt-N

audit-dashboard

Consolidate real-time HR-IMS audit events into a unified monitoring dashboard.

Community
Advanced
viqueenviqueen
1

review-entity-store

Audit pull requests for entity store SQL migrations, sqlc queries, and proto consistency.

Community
Intermediate
FrancisVargaFrancisVarga

Compute Algorithms

Guide machine learning algorithm selection and parameter tuning for data analysis.

Community
Intermediate