exasol-labs
- 40 skills
- 0 followers
- 54 repo stars
- 6 days ago last updated
- ▌ Speq Spec Merge · exasol-labsDelta-merge procedure — DELTA marker semantics, library-organization thresholds, and ADR-promotion field mapping. Used by /speq-record when recording a plan's deltas.
- ▌ Speq Code Review · exasol-labs bundleCode review tag taxonomy and findings format for the code-reviewer agent during /speq-implement. Not for general code review.
- ▌ Speq Ext Library · exasol-labsLooks up current library documentation (APIs, method signatures, usage examples) through Context7 when it is installed. Use when a task depends on a library's current API, version-specific behavior, or setup.
- ▌ Speq Plan Review · exasol-labs bundleAdversarial plan-review method: challenge taxonomy, severity rules, and findings format. Used by the plan-reviewer agent when reviewing a plan.
- ▌ Speq Implement Pr · exasol-labsBuilds a planned feature on its feat/plan-name branch as a follow-up to /speq-plan-pr: implements, bumps the version, runs the real test suites, records the specs if green, comments the verification, and marks the PR ready. Run again to resume. Arg: plan name, PR number, or branch name.
- ▌ Speq Git Discipline · exasol-labsRead-only git guardrails. No history writes, verify changes before completing. Used by speq agents. Not for general git work.
- ▌ Speq Git Operations · exasol-labsThe git/gh operation-to-command mapping, return formats, and PR-title and version-bump rules, invoked directly by /speq-plan-pr, /speq-implement-pr, and /speq-patch-pr.
- ▌ Speq Code Guardrails · exasol-labsTDD cycle and code quality guardrails for the implementer and reviewer agents during /speq-implement. Not for general coding.
- ▌ Speq Design Philosophy · exasol-labsComplexity-management design principles (deep modules, information hiding, dependency direction) for speq agents like /speq-plan or /speq-implement. Not for general design work.
- ▌ Speq Writing Guardrails · exasol-labsNine prose rules for speq artifacts and PR text: conclusion first, one idea per sentence, named actors, plain words, no filler, no em dashes. Not for general writing.
- ▌ Speq CLI · exasol-labsQueries specs via the speq CLI: list and read features, validate structure, run the absence check. Invoke first for any spec discovery or validation.
- ▌ Speq Plan · exasol-labs bundlePlans a feature or change through a clarifying interview, producing spec deltas, plan.md, and decision-log.md with adversarial review. Use to plan, spec, design, or scope a feature, change, removal, refactor, or fix, before any implementation.
- ▌ Speq Audit · exasol-labs bundleAudits a speq project's health: specs, decision logs, plans, mission sync, unrecorded plans, and gitignore hygiene. Use when asked to audit, health-check, or check a project build with speq-skill.
- ▌ Speq Patch · exasol-labsApplies a bug fix, small feature, or tweak in the working tree in one run: implements and tests it, has code-reviewer review the diff once, and edits only the specs, ADRs, architecture, and docs it needs. Runs no git writes. Arg: change intent text.
- ▌ Speq Record · exasol-labsMerges implemented spec deltas into the permanent specs and archives the plan. Use after /speq-implement, or to record, merge, or archive a finished plan. Arg: plan-name.
- ▌ Speq Mission · exasol-labs bundleCreates or updates specs/mission.md and specs/architecture.md through an interview, for brownfield or greenfield projects. Use to bootstrap a speq project, revise the mission, or when /speq-audit reports mission drift.
- ▌ Speq Plan Pr · exasol-labs bundlePlans a feature through the same clarifying interview as /speq-plan, then creates the feat/plan-name branch, commits the plan, and opens a draft pull request. Arg: feature intent text, plan name, PR number, or branch name.
- ▌ Speq Patch Pr · exasol-labs bundleShips a bug fix, small feature, or tweak as one ready PR: runs /speq-patch on the patch/patch-name branch, bumps the version, commits, and opens a ready pull request. Run again to resume. Arg: change intent text.
- ▌ Speq Planning · exasol-labs bundlePlan-authoring workflow for the planner-agent: spec deltas, test mapping, plan.md, decision-log.md, expert tagging, and revision mode.
- ▌ Speq Adr Rules · exasol-labsWhen a decision becomes an ADR: the default is no, only durable decisions qualify, search first, one decision per ADR. Use inside a /speq-plan, /speq-record, /speq-patch, or /speq-audit run.
- ▌ Speq Implement · exasol-labs bundleImplements a reviewed plan: task breakdown, TDD sub-agents, code review, and a verification report. Use to build or execute a plan under specs/_plans/, after /speq-plan and before /speq-record. Arg: plan-name.
- ▌ Speq Code Tools · exasol-labsSemantic code navigation and editing via Serena MCP, required over grep and manual edits. Used by speq agents like /speq-implement. Not for general coding.
- ▌ Exasol · exasol-labsTop-level router for Exasol work. Use for any Exasol database, exapump, SQL, BucketFS, extension, integration, UDF, Script Language Container, or Exasol Personal setup task, then route to the narrowest specialized Exasol skill.
- ▌ Exasol Itde · exasol-labs bundleUse notebook-connector's itde_manager to run a local Docker-based Exasol database. Covers bring_itde_up, get_itde_status, restart_itde, take_itde_down, and how ITDE populates notebook-connector configuration automatically.
- ▌ Exasol Udfs · exasol-labs bundleExasol User Defined Functions (UDFs) and Script Language Containers (SLCs). Covers `CREATE SCRIPT`, SCALAR and SET functions, variadic scripts with `EMITS(...)` and `default_output_columns`, the `ExaIterator` and `ExaMetadata` APIs, Python, Java, Lua, and R scripts, Lua execute scripts and `pquery`, BucketFS file access, GPU-accelerated UDFs, `ALTER SESSION SET SCRIPT_LANGUAGES` activation, and building custom Script Language Containers with `exaslct`, `exaslpm`, and `packages.yml`.
- ▌ Exasol Export · exasol-labs bundleUse Exasol `EXPORT` and `EXPORT INTO` SQL plus `exapump export` local file workflows for moving data out of Exasol. Covers native CSV/FBV export, local CSV/Parquet exports with exapump, `CREATE CONNECTION` connection objects for export, FTP, SFTP, HTTP, HTTPS, and cloud targets on S3, Azure Blob Storage, and Google Cloud Storage (GCS), reject limits, and export credential patterns.
- ▌ Exasol Import · exasol-labs bundleUse Exasol `IMPORT` and `IMPORT INTO` SQL plus `exapump upload` local file workflows for moving data into Exasol. Covers CSV, FBV, and Parquet, `CREATE CONNECTION` connection objects for import, cloud credential patterns for S3, Azure Blob Storage, and Google Cloud Storage (GCS), reject handling, and staging-based import workflows. Native IMPORT does not read Avro, ORC, or Delta — those object-storage formats need the Cloud Storage Extension instead.
- ▌ Exasol Text AI · exasol-labs bundleDeploy and use the Exasol Text AI Extension (TXAIE) with notebook-connector. Covers `deploy_license`, `initialize_text_ai_extension`, the `PYTHON3_TXAIE` language container, the Extraction API classes `StandardExtractor`, `NamedEntityExtractor`, `TopicClassifierExtractor`, `PipelineExtractor`, and `BranchExtractor`, named-entity, zero-shot classification, and feature extraction runs, default-model installation, and result-table querying such as `TXAIE_AUDIT_LOG`.
- ▌ Exasol Bucketfs · exasol-labs bundleExasol BucketFS file system management via the `exapump bucketfs` CLI. Covers listing, uploading, downloading, and deleting files and directories in BucketFS, the `bfsdefault` service and other bucket services, bucket structure, `bfs_*` profile settings, the `/buckets/<service>/<bucket>/<path>` UDF path, and staging JARs, models, and Script Language Containers for UDFs.
- ▌ Exasol Database · exasol-labs bundleExasol database interaction via the exapump CLI and Exasol SQL. Covers SQL queries and DML/DDL such as `SELECT`, `INSERT`, `UPDATE`, `DELETE`, `MERGE`, `CREATE TABLE`, `ALTER TABLE`, and `DROP TABLE`, `CREATE CONNECTION` connection objects without import or export intent, schema inspection, table design, `exapump sql` and `exapump profile`, query profiling, analytics, and Exasol-specific SQL behavior outside exasol-import and exasol-export.
- ▌ Exasol Transformers · exasol-labs bundleDeploy and use the Exasol Transformers Extension (TE) for NLP inference inside Exasol with notebook-connector. Covers `initialize_te_extension`, `deploy_scripts`, `PYTHON3_TE` language-container activation SQL, Hugging Face model-installation workflows, and the current TE SQL UDF surface.
- ▌ Exasol Distributed Ml · exasol-labs bundleDistributed machine learning, data mining, and iterative HPC with Exasol. Covers end-to-end ML pipelines (DISTRIBUTE BY + SET scripts + BucketFS), per-entity federated training with partial_fit and ctx.reset(), batch inference, map-reduce ensemble training, distributed ensemble and SON algorithm for frequent itemset mining (Apriori, FP-Growth, association rules, market-basket analysis), Lua execute script orchestration for iterative algorithms (k-means, SGD, gradient descent), scikit-learn model training, parallel hyperparameter search, per-entity forecasting, anomaly detection, model lifecycle in BucketFS (pickle/joblib/ONNX versioning), GPU acceleration via CUDA SLCs (PyTorch/TensorFlow/RAPIDS), and ML-specific performance tuning (skew, OOM, multi-pass chunking).
- ▌ Exasol Setup Personal · exasol-labs bundleGuided setup of Exasol Personal — a free Exasol database running locally on a Mac or deployed to your own AWS, Azure, Exoscale, or STACKIT account. Covers picking the right deployment flavor, the `exasol` launcher CLI (`exasol install <preset>`, `exasol connect`, `exasol info`, `exasol deployments list`, `exasol destroy`), the `local`, `aws`, `azure`, `exoscale`, and `stackit` presets, and following the official exasol/exasol-personal instructions.
- ▌ Exasol Extension Catalog · exasol-labs bundleCatalog and selection guide for Exasol tools, extensions, connectors, integrations, and architecture patterns. Use when the primary intent is comparison, discovery, support-status research, or architecture selection rather than executing a workflow; hand operational work to the selected dedicated skill. Covers deploy, load, explore, enrich, surface, and scale capability families, including named products with no dedicated skill of their own such as Lakehouse Turbo, the Exasol MCP Server, Governed SQL / Text-to-SQL MCP Server, Agent Control Plane, Extension Manager, Terraform and Ansible tooling, and BI, ETL, and warehouse integrations such as Databricks, SAP, Kafka, Power BI, and Tableau.
- ▌ Exasol Jdbc Virtual Schemas · exasol-labs bundleUse Exasol JDBC-based virtual schemas for federated read-only access to external databases such as PostgreSQL, Oracle, MySQL, SQL Server, and DB2. Covers database-source adapter selection, `CREATE VIRTUAL SCHEMA`, `ALTER VIRTUAL SCHEMA`, `EXPLAIN VIRTUAL`, metadata refresh, and query-side troubleshooting.
- ▌ Exasol Notebook Connections · exasol-labs bundleUse notebook-connector's Python connection helpers for Exasol, BucketFS, SQLAlchemy, and Ibis. Covers open_pyexasol_connection, open_sqlalchemy_connection, open_ibis_connection, open_bucketfs_bucket, open_bucketfs_location, get_backend, and related helper functions.
- ▌ Exasol Cloud Storage Extension · exasol-labs bundleUse Exasol Cloud Storage Extension workflows for moving structured object-storage files through extension UDFs. Covers setup prerequisites, the fixed `CLOUD_STORAGE_EXTENSION.IMPORT_PATH` and `CLOUD_STORAGE_EXTENSION.EXPORT_PATH` entrypoints used with `FROM SCRIPT` and `INTO SCRIPT`, Parquet, Avro, ORC, and Delta files on S3, Google Cloud Storage, Azure Blob Storage, Azure Data Lake, HDFS, and Alluxio, connection-object credential patterns, and routing away from native IMPORT or EXPORT when the extension path is the right fit.
- ▌ Exasol Document Virtual Schemas · exasol-labs bundleUse Exasol document-file virtual schemas for federated read-only access to object and file storage — S3, Google Cloud Storage, Azure Blob Storage, and Azure Data Lake Storage Gen2 document files. Covers document-file adapter family selection, the EDML `MAPPING` definition, `CREATE VIRTUAL SCHEMA` usage, refresh workflows, and query-side troubleshooting.
- ▌ Exasol Notebook Connector Config · exasol-labs bundleSet up notebook-connector configuration for Exasol AI workflows through the Secrets Python API. Covers secure config store (`scs`) creation, the `AILabConfig` and `StorageBackend` key sources, backend-specific config values such as `db_host_name`, `db_schema`, `storage_backend`, and `huggingface_token`, Python validation, and handoff to downstream notebook-connector skills.
- ▌ Exasol Virtual Schema Adapter Development · exasol-labs bundleBuild, install, validate, and debug custom Exasol virtual schema adapters. Covers source-specific JDBC dialect implementation with `virtual-schema-common-jdbc` including `SqlDialect`, metadata reader behavior, type mapping, and pushdown capabilities, custom document-file adapter code boundaries, custom adapter properties, JAR packaging, BucketFS deployment, adapter script setup, `EXPLAIN VIRTUAL` validation, and adapter-side remote debugging workflows.