SQL & Databases

majiayu000 Bundle

Designs Elasticsearch indexes and mappings, tunes queries, sizes clusters, and handles operations like shard/replica strategy, ILM, monitoring, troubleshooting, and safe reindexing or upgrades.

ecnu-icalk Skill

Executes MySQL database development and review tasks based on user-provided rules, covering naming constraints, index design, and data archiving for large datasets.

ecnu-icalk Skill

Generates SQL queries against a custom database schema (Vika/Airtable-like) to look up table names, dst_ids, records, and field metadata.

agentskillexchange Skill

Installs the Snowflake Connector for Python and builds a wheel package using PEP-517.

agentskillexchange Skill

Analyze SQLite databases using the better-sqlite3 Node.js library, including querying, inserting, and iterating over rows.

agentskillexchange Skill

Sets up a Node.js project to use the AWS SDK for JavaScript v3 and make DynamoDB service calls.

agentskillexchange Skill

Provides a quick start guide to Redis, including installation via Docker, building from source, and links to client libraries for Python and JavaScript.

agentskillexchange Skill

Runs MySQL queries from an AI coding agent using the mysql2 Node.js library, with setup instructions for npm and TypeScript.

agentskillexchange Skill

Provides a lightweight local SQLite database access layer for AI agents via an MCP server, with installation and usage guidance.

redpanda-data Bundle

Write and run analytical SQL queries against Redpanda SQL (Oxla), a distributed PostgreSQL-wire-compatible columnar database, including data loading, external sources, and type handling.

redpanda-data Bundle

Manage schemas, subjects, compatibility levels, modes, and contexts in the Redpanda Schema Registry via the rpk registry CLI. Register or fetch Avro, Protobuf, and JSON schemas, set compatibility levels, change registry mode, and work with schema contexts.

redpanda-data Bundle

Streams change data capture from Oracle Database into Redpanda or Kafka using the oracledb_cdc input in Redpanda Connect, which reads redo logs via LogMiner. Covers configuration, Oracle setup, checkpointing, and enterprise features.

redpanda-data Bundle

Streams change data capture from MongoDB into Redpanda or Kafka using Redpanda Connect's mongodb_cdc input, covering Change Streams, snapshots, document modes, and resume-token checkpointing.

redpanda-data Bundle

Streams change data capture from PostgreSQL into Redpanda or Kafka using Redpanda Connect's postgres_cdc input, covering setup, snapshotting, and troubleshooting.

redpanda-data Bundle

Streams change data capture from Microsoft SQL Server into Redpanda or Kafka using Redpanda Connect's microsoft_sql_server_cdc input, covering setup, configuration, and troubleshooting.

redpanda-data Bundle

Streams change data capture events from a TigerBeetle financial transactions database into Redpanda or Kafka using the tigerbeetle_cdc input, with checkpointing, filtering, and routing guidance.

pranavnagrecha Bundle

Maps the Salesforce CPQ managed-package object graph (SBQQ__ namespace) and explains when to use the CPQ Quote API for programmatic writes instead of direct DML.

pranavnagrecha Bundle

Explains the Financial Services Cloud data model, covering managed-package and Core FSC object structures, household relationships, financial account ownership, and the rollup framework, with SOQL query patterns.

pranavnagrecha Bundle

Understand and query the NPSP data model, including namespace prefixes, GAU allocations, recurring donations, relationships, and affiliations.

pranavnagrecha Bundle

Enables, configures, and troubleshoots Salesforce Person Accounts, covering data model design, IsPersonAccount flag handling, reporting impact, migration planning, and integration requirements.

pranavnagrecha Bundle

Write and debug SOQL queries covering SELECT syntax, filters, sorting, pagination, relationship traversal, and aggregate functions.

pranavnagrecha Bundle

Guides composing SOSL FIND queries with result-scoping or result-shaping WITH clauses, covering clause order, supported objects, field-type limits, and API-version floors.

pranavnagrecha Bundle

Write SOQL queries that group or filter records by date periods using the 13 SOQL date functions, with rules for WHERE vs GROUP BY placement, date-literal comparisons, and fiscal-year restrictions.

lingxling Bundle

Provides guidance on using the Astropy library for astronomy and astrophysics workflows, including units, coordinates, FITS I/O, tables, time, WCS, and cosmology.

leandrobenjaminl Bundle

Analiza datos en bases de datos relacionales con consultas SQL eficientes y legibles, incluyendo joins, window functions, CTEs y subqueries, para extraer insights directamente de la base de datos.

sakamoto-family-smile Skill

Analyze Claude Code token usage, spending, and budgets from a local SQLite cost-tracking database, with breakdowns by project, tool, session, or date.

lord1egypt Skill

Interact with Airtable bases, tables, and records via the REST API using curl commands, covering CRUD operations, filtering, sorting, pagination, and upserts.

lord1egypt Skill

Search, read, create, update, and delete blocks and documents in a self-hosted SiYuan knowledge base via its kernel API using curl.

pwdev-solucoes Skill

Guides backup, restore, snapshot, PITR, retention, and disaster recovery planning for PostgreSQL and AWS, emphasizing tested restores and RTO/RPO alignment.

pwdev-solucoes Skill

Executa consultas, inspeção de schema e mutações seguras (DML/DDL com dry-run) no PostgreSQL via servidor MCP, exigindo confirmação explícita para alterações.

zero-yx Bundle

Generates one-day Kiro credit usage reports from LanceDB usage events, with China-time windows, global totals, and account subset breakdowns.

zero-yx Bundle

Publishes Markdown articles and images into LanceDB via the sf-cli tool, syncs notes, infers missing metadata, and verifies results with local API checks.

joshuashepherd Skill

Upserts a validated MDX book corpus into Supabase via Drizzle, hydrating books, chapters, sections, and chunks tables while preserving stable bookmark anchors and only re-embedding changed content.

luokai0 Bundle

Teaches standard SQL for creating, managing, and querying relational databases, covering DDL, DML, DQL, DCL, joins, subqueries, and best practices.

jorcan Bundle

Create and manage ODB databases, connect to external databases, and automate forms, reports, and data operations with LibreOffice Base.

jorcan Bundle

Guides configuring connection pooling for Postgres to prevent connection exhaustion under load.