skills.rest
redpanda-data
redpanda-dataOFFICIAL
Explore all skills by this author →
Website𝕏@redpandadataGitHub

sql

Query Oxla distributed analytics data with PostgreSQL-compatible SQL.

6|3|Updated May 31, 2026
Search Tags:#postgresql#sql#data-analytics#copy#ctas#external-sources#oxla
One-click install
npx skills add https://github.com/redpanda-data/skills --skill sql-redpanda-data
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: sql
Source: https://github.com/redpanda-data/skills/tree/main/skills/sql
Command: npx skills add https://github.com/redpanda-data/skills --skill sql-redpanda-data

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

Write and run SQL against Oxla, a PostgreSQL-wire-compatible distributed analytics database, enabling familiar SQL workflows with Oxla-specific extensions such as external sources and Iceberg catalogs.

Core Features & Use Cases

  • PostgreSQL-compatible SQL with Oxla extensions (external sources, CTAS, COPY, and Iceberg catalogs) for analytics workloads.
  • Full DDL/DML coverage including CREATE/ DROP / TRUNCATE / VIEWs / PREPARE/EXECUTE / COPY FROM/TO / SELECT INTO to model, load, and query across distributed data.
  • Use cases include querying Redpanda Kafka topics and Iceberg tables via catalog=>table syntax, loading data from CSV/Parquet/ORC, and materializing results with CTAS or SELECT INTO.
  • The Skill serves as a comprehensive reference to map PostgreSQL concepts to Oxla's distributed execution model.

Quick Start

Connect to Oxla using psql and start running the sample queries shown in this Skill's Quick Start.

Frequently Asked Questions about sql

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

FAQPage Schema
How do I query Kafka topics and Iceberg tables using PostgreSQL-compatible SQL?▼

You query Kafka topics and Iceberg tables using PostgreSQL-compatible SQL via Oxla's external sources feature, applying a catalog=>table syntax to access distributed data directly through familiar SQL workflows.

Can I use standard PostgreSQL DDL and DML commands to build data pipelines in Oxla?▼

Yes, you can use standard PostgreSQL DDL and DML commands in Oxla to build data pipelines, with full coverage for CREATE, DROP, TRUNCATE, VIEWs, PREPARE, EXECUTE, and COPY operations across distributed data.

What is the best way to load CSV, Parquet, or ORC files into a distributed analytics database?▼

The best way to load CSV, Parquet, or ORC files into a distributed analytics database is using the COPY FROM command within Oxla, which supports ingesting these file formats directly into your analytics tables.

Does Oxla support CTAS and SELECT INTO for materializing query results?▼

Oxla supports CTAS (CREATE TABLE AS SELECT) and SELECT INTO for materializing query results, allowing you to create new tables and persist derived data sets from your distributed analytics queries.

How do I connect to Oxla to start running PostgreSQL-compatible queries?▼

You connect to Oxla using the psql command-line client, which leverages the PostgreSQL wire protocol support to let you immediately run SQL queries against your distributed analytics data.

What are the limitations when mapping PostgreSQL concepts to Oxla's distributed execution model?▼

The primary limitation when mapping PostgreSQL concepts to Oxla's distributed execution model is understanding Oxla-specific extensions like external sources and Iceberg catalogs, which require referencing the provided SKILL.md documentation for correct usage.

Related Skills

Explore More Data & Analytics Skills→
huydepzai121huydepzai121
3

postgresql-psql

Execute PostgreSQL psql commands for connections, queries, and administration.

Community
Intermediate
CyangZhouCyangZhou
2

python_data_analyst

Automate Pandas data cleaning, analysis, and visualization with Matplotlib/Seaborn.

Community
Intermediate
redpanda-dataredpanda-data
6

sql-federated-queries

Create Kafka/Iceberg catalogs to federate Oxla queries across external sources.

Official
Advanced
opzero1opzero1
3

databases

Automate PostgreSQL and MongoDB patterns for data modeling, indexing, and migrations.

Official
Intermediate