SQL & Databases

projectopensea Bundle

Query NFT and token data, browse drops, stream events, and search across Ethereum, Base, Arbitrum, Optimism, Polygon, and more using the official CLI, SDK, MCP server, or shell scripts.

majiayu000 Bundle

Run SQL queries and psql meta-commands against PostgreSQL databases via the psql CLI, with options for file execution, tuples-only output, and timeouts.

ecnu-icalk Skill

Designs a points account system supporting multiple point types, independent expiration times, and FEFO (first-expired-first-out) consumption logic, including database schema, data flow, balance display, and partial consumption handling.

redpanda-data Bundle

Streams MySQL or MariaDB row-level changes into Redpanda or Kafka via the mysql_cdc input, covering binlog setup, snapshots, checkpointing, per-table routing, AWS RDS IAM auth, and Enterprise lakehouse destinations.

redpanda-data Bundle

Query external data from Oxla — Kafka topics via catalogs, Apache Iceberg tables, and S3/GCS/Azure parquet/ORC files — alongside native Oxla tables. Use when querying Kafka topics with CREATE KAFKA CATALOG or CREATE REDPANDA CATALOG, reading Apache Iceberg tables with the catalog=>path.table syntax, loading or.

pranavnagrecha Bundle

Routes to the right Salesforce data skill package for data model, migration, bulk loads, query optimization, deduplication, and archival tasks.

nimoqup046-collab Skill

Provides expert guidance on modern SQL, cloud-native databases, and query optimization, covering performance tuning, data modeling, and hybrid analytical systems.

sakamoto-family-smile Skill

Provides JPA/Hibernate patterns for Spring Boot data modeling, including entity design, relationships, query optimization, transactions, auditing, indexing, pagination, and connection pooling.

sakamoto-family-smile Skill

Provides ClickHouse schema design, query optimization, and data ingestion patterns for high-performance analytical workloads.

sakamoto-family-smile Skill

Provides MySQL and MariaDB schema, query, indexing, transaction, replication, and connection-pool patterns for production backends.

sakamoto-family-smile Skill

Production patterns and non-obvious traps for Prisma ORM in TypeScript backends, covering schema design, query optimization, transactions, pagination, and serverless connection handling.

pwdev-solucoes Skill

Diagnoses and tunes PostgreSQL performance issues such as slow queries, missing indexes, bloat, locks, and connection problems, providing SQL commands and best practices.

zero-yx Skill

Compacts and prunes LanceDB tables in StaticFlow databases to merge fragment files, reduce open file descriptors, and reclaim storage.

luokai0 Bundle

Guides database design and operations to avoid common scaling, reliability, and data integrity pitfalls.

luokai0 Bundle

Guides OLTP database schema design through six stages: domain and access patterns, entities and relationships, keys and constraints, normalization trade-offs, indexing and performance, and operations and evolution. Includes a final review checklist and tips for effective guidance.

luokai0 Bundle

Collects Chinese A-share stock data, fetching stock lists and daily, weekly, and monthly K-line history into a local SQLite database for quantitative analysis.

jorcan Bundle

Performs astronomical data analysis with astropy: coordinate transformations, unit conversions, FITS file handling, cosmological calculations, time systems, tables, and WCS.

jorcan Bundle

Guides database design, implementation, optimization, migration, pipeline development, quality, and operations across SQL and NoSQL platforms.

clawbio Bundle

Generates a personalised nutrition report from consumer genetic data (23andMe, AncestryDNA, VCF) by interrogating nutritionally-relevant SNPs and producing actionable dietary guidance, all computed locally.

gabrielmoreira Bundle

Computes phylogenetic distance matrices and trees from genomic VCF or FASTA data using the fastreeR hybrid Java/Python toolkit.

gabrielmoreira Bundle

Performs HLA allele genotyping from WGS/WES VCF data, producing a structured markdown report and machine-readable JSON results.

neuralblitz Skill

Explains ACID transaction properties and provides Python implementations for atomic operations, consistency validation, isolation levels, and durable storage.

mariadb-corporation Skill

Explains MariaDB-specific SET syntax and behavior, including scope rules, the SET STATEMENT ... FOR extension, and persistence differences from MySQL.

mariadb-corporation Skill

Decodes and replays MariaDB binary logs with correct flags: commented pseudo-SQL vs. executable BINLOG blobs, ANNOTATE_ROWS events, flashback undo SQL, and safe replay via the mariadb client.

mariadb-corporation Skill

Explains MariaDB server-side prepared statements (PREPARE, EXECUTE, DEALLOCATE, EXECUTE IMMEDIATE), including syntax, allowed statements, placeholders, session scope, and restrictions. Use when writing or reviewing dynamic SQL for MariaDB.

mariadb-corporation Skill

Explains MariaDB-specific syntax and behavior for LOAD DATA [LOCAL] INFILE and LOAD XML, including LOCAL vs server-side file handling, security and privilege requirements, default tab/newline parsing, duplicate and strict-mode caveats, IGNORE n LINES, user-variable SET transforms, CHARACTER SET clause, and priority.

mariadb-corporation Skill

Explains MariaDB-specific view syntax and behavior, including CREATE OR REPLACE VIEW, ALGORITHM options, SQL SECURITY, updatability rules, and WITH CHECK OPTION, for writing or reviewing MariaDB view statements.

mariadb-corporation Skill

Documents MariaDB-specific transaction control syntax and behavior, including START TRANSACTION, COMMIT, ROLLBACK, SAVEPOINT, implicit commit rules, autocommit defaults, and idle transaction timeouts.

mariadb-corporation Skill

Explains MariaDB's three CREATE FUNCTION forms — stored functions, stored aggregate functions, and loadable UDFs — covering syntax, privileges, and behavior differences for writing or reviewing MariaDB SQL.

mariadb-corporation Skill

Reference for MariaDB's vector functions and VECTOR data type, covering VEC_Distance, VEC_Distance_Euclidean, VEC_Distance_Cosine, VEC_FromText, VEC_ToText, and MHNSW vector index usage for SQL queries over embeddings.

mariadb-corporation Skill

Reference for MariaDB information functions, covering session and server metadata such as LAST_INSERT_ID, ROW_COUNT, FOUND_ROWS, USER, and VERSION, with usage guidance for writing SQL that reads auto-increment IDs, row counts, and connection details.

mariadb-corporation Skill

Reference for MariaDB control-flow functions and operators, including IF(), IFNULL(), NULLIF(), COALESCE(), CASE, NVL2(), and DECODE_ORACLE, with guidance on correct usage and common pitfalls.

mariadb-corporation Skill

Scaffold a MariaDB Schema Management (MSM) project and author the initial schema in the development folder, creating the project with msm.create_project and writing the first version's tables, objects, and grants into the MSM sections of <schema>_next.sql.

mariadb-corporation Skill

Modify existing MariaDB REST Service endpoints using ALTER and DROP REST statements, including renaming request paths, enabling/disabling, publishing, and merging JSON options.

mhassan0000 Skill

Provides ClickHouse-specific patterns for schema design, query optimization, data ingestion, and analytics, including materialized views and performance monitoring.

diegosouzapw Bundle

Manage Amazon Aurora DSQL clusters, schemas, and migrations with MCP tools and CLI scripts, including multi-tenant patterns and IAM-based authentication.