AI Skill Library

All domains › Data & Databases

Data & Databases

64 skills across 7 categories.

Caching (8)

  • azure-resource-manager-redis-dotnetAzure Resource Manager SDK for Redis in .NET.risk: mediumFree
  • cache-expertCovers Dagger Engine caching internals including cache key derivation, invalidation, and the immutable DAG model. Use when debuggirisk: lowFree
  • content-hash-cache-patternCache expensive file processing results using SHA-256 content hashes — path-independent, auto-invalidating, with service layer seprisk: lowFree
  • memory-cacheHigh-performance temporary storage system using Redis. Supports namespaced keys (mema:*), TTL management, and session context cachrisk: lowFree
  • redis-expertRedis expert for data structures, caching patterns, Lua scripting, and cluster operationsrisk: lowFree
  • redis-inspectInspect Redis cache keys, values, and TTLs for debugging. Supports both main cache and system cache. Use for debugging cache issuerisk: lowFree
  • serverpod-cachingServerpod caching — local and Redis caches, cache keys, lifetime, CacheMissHandler. Use when caching data, optimizing queries, or risk: lowFree
  • upstash-ratelimit-tsLightweight guidance for using the Redis Rate Limit TypeScript SDK, including setup steps, basic usage, and pointers to advanced arisk: lowFree

Data engineering & pipelines (19)

  • add-database-engineGuided implementation for adding a new database engine to TablePro. Pre-loaded with all integration points, file locations, patterrisk: lowFree
  • airflow-dag-patternsBuild production Apache Airflow DAGs with best practices for operators, sensors, testing, and deployment. Use when creating data prisk: lowFree
  • azure-ai-anomalydetector-javaBuild anomaly detection applications with Azure AI Anomaly Detector SDK for Java. Use when implementing univariate/multivariate anrisk: lowFree
  • bloblang-authoringThis skill should be used when users need to create or debug Bloblang transformation scripts. Trigger when users ask about transforisk: mediumFree
  • data-managerUse this skill when using the Phaser 4 DataManager to store custom key-value data on game objects, listen for data change events, risk: lowFree
  • data-processingProcess and transform structured data files.risk: lowFree
  • data-scientistExpert data scientist for advanced analytics, machine learning, and statistical modeling. Handles complex data analysis, predictivrisk: lowFree
  • database-lookupSearch 78 public scientific, biomedical, materials science, and economic databases via REST APIs. Covers physics/astronomy (NASA, risk: mediumFree
  • dbt-transformation-patternsMaster dbt (data build tool) for analytics engineering with model organization, testing, documentation, and incremental strategiesrisk: mediumFree
  • Excel AnalysisAnalyze Excel spreadsheets, create pivot tables, generate charts, and perform data analysis. Use when analyzing Excel files, sprearisk: lowFree
  • exploratory-data-analysisPerform comprehensive exploratory data analysis on scientific data files across 200+ file formats. This skill should be used when risk: lowFree
  • exploratory-data-analysisComprehensive exploratory data analysis across 200+ scientific file formats: auto-detects file type and generates detailed markdowrisk: lowPremium
  • Firecrawl ScrapeScrape web pages and extract content via Firecrawl MCPrisk: lowFree
  • geopandasPython library for working with geospatial vector data including shapefiles, GeoJSON, and GeoPackage files. Use when working with risk: lowFree
  • jupyter-live-kernelUse a live Jupyter kernel for stateful, iterative Python execution via hamelnb. Load this skill when the task involves explorationrisk: lowFree
  • notebookManage DeepTutor notebooks — list, create, view, import and remove records.risk: lowFree
  • odoo-backup-strategyComplete Odoo backup and restore strategy: database dumps, filestore backup, automated scheduling, cloud storage upload, and testerisk: lowFree
  • regex-vs-llm-structured-textDecision framework for choosing between regex and LLM when parsing structured text — start with regex, add LLM only for low-confidrisk: lowFree
  • table-extraction-and-reconstructiontaule extraction and reconstructionrisk: lowFree

Data visualization (5)

  • chart-visualizationThis skill should be used when the user wants to visualize data. It intelligently selects the most suitable chart type from 26 avarisk: lowFree
  • data-storytellingTransform data into compelling narratives using visualization, context, and persuasive structure. Use when presenting analytics torisk: lowFree
  • matplotlibMatplotlib is Python's foundational visualization library for creating static, animated, and interactive plots.risk: lowFree
  • plotlyInteractive visualization library. Use when you need hover info, zoom, pan, or web-embeddable charts. Best for dashboards, explorarisk: lowFree
  • visualization-expertChart selection and data visualization guidance for effective data communication. Use when: creating visualizations, choosing charrisk: lowFree

Migrations (6)

  • database-migrationExecute database migrations across ORMs and platforms with zero-downtime strategies, data transformation, and rollback procedures.risk: mediumFree
  • database-migrationsDatabase migration best practices for schema changes, data migrations, rollbacks, and zero-downtime deployments across PostgreSQL,risk: mediumFree
  • database-migrationsComplete database migrations super-skill: safe schema-change patterns (add column/index without downtime), zero-downtime strategierisk: mediumPremium
  • database-migrations-migration-observabilityMigration monitoring, CDC, and observability infrastructurerisk: mediumFree
  • database-migrations-sql-migrationsSQL database migrations with zero-downtime strategies for PostgreSQL, MySQL, and SQL Server. Focus on data integrity and rollback risk: mediumFree
  • discourse-migrationMUST load before writing or reviewing any database migration (db/migrate, db/post_migrate, plugin migrations)risk: mediumFree

NoSQL & document (3)

  • abp-mongodbABP MongoDB patterns – AbpMongoDbContext, IMongoCollection, MongoDbRepository, no migrations, embedded documents vs references, marisk: lowFree
  • cosmosdb-datamodelingStep-by-step guide for capturing key application requirements for NoSQL use-case and produce Azure Cosmos DB Data NoSQL Model desirisk: mediumFree
  • db-core-collection-setupCreating typed collections with createCollection. Adapter selection: queryCollectionOptions (REST/TanStack Query), electricCollectrisk: lowFree

Relational / SQL (17)

  • azure-postgres-tsConnect to Azure Database for PostgreSQL Flexible Server from Node.js/TypeScript using the pg (node-postgres) package.risk: highFree
  • azure-resource-manager-mysql-dotnetAzure MySQL Flexible Server SDK for .NET. Database management for MySQL Flexible Server deployments.risk: mediumFree
  • azure-resource-manager-postgresql-dotnetAzure PostgreSQL Flexible Server SDK for .NET. Database management for PostgreSQL Flexible Server deployments.risk: mediumFree
  • claimable-postgresProvision instant temporary Postgres databases via Claimable Postgres by Neon (pg.new). No login or credit card required. Use for risk: mediumFree
  • clickhouse-ioClickHouse database patterns, query optimization, analytics, and data engineering best practices for high-performance analytical wrisk: lowFree
  • database-designDatabase design principles and decision-making. Schema design, indexing strategy, ORM selection, serverless databases.risk: lowFree
  • database-optimizerExpert database optimizer specializing in modern performance tuning, query optimization, and scalable architectures.risk: lowFree
  • databasesWork with MongoDB (document database, BSON documents, aggregation pipelines, Atlas cloud) and PostgreSQL (relational database, SQLrisk: mediumFree
  • index-at-creationIndex at Creation Timerisk: lowFree
  • kotlin-exposed-patternsJetBrains Exposed ORM patterns including DSL queries, DAO pattern, transactions, HikariCP connection pooling, Flyway migrations, arisk: mediumFree
  • neon-postgresExpert patterns for Neon serverless Postgres, branching, connection pooling, and Prisma/Drizzle integrationrisk: lowFree
  • oracleBest practices for using the oracle CLI (prompt + file bundling, engines, sessions, and file attachment patterns).risk: lowFree
  • postgres-patternsPostgreSQL database patterns for query optimization, schema design, indexing, and security. Based on Supabase best practices.risk: lowFree
  • postgres-patternsPostgreSQL database patterns for query optimization, schema design, indexing, and security. Quick reference for common patterns, irisk: lowFree
  • postgresql-table-designComplete database design & optimization super-skill: PostgreSQL schema design (data types, constraints, RLS, indexing), query optirisk: mediumPremium
  • sql-optimization-patternsMaster SQL query optimization, indexing strategies, and EXPLAIN analysis to dramatically improve database performance and eliminatrisk: lowFree
  • whodbDatabase operations including querying, schema exploration, and data analysis. Activates for tasks involving PostgreSQL, MySQL, Marisk: lowFree

Search & vector (6)

  • agentdb-vector-search"Implement semantic vector search with AgentDB for intelligent document retrieval, similarity matching, and context-aware queryingrisk: lowFree
  • elasticsearchElasticsearch expert for queries, mappings, aggregations, index management, and cluster operationsrisk: mediumFree
  • meilisearch-adminCheck Meilisearch index status, tasks, health, and settings. Use for debugging search issues, monitoring indexing tasks, and insperisk: lowFree
  • similarity-search-patternsImplement efficient similarity search with vector databases. Use when building semantic search, implementing nearest neighbor querrisk: lowFree
  • vector-database-engineerExpert in vector databases, embedding strategies, and semantic search implementation. Masters Pinecone, Weaviate, Qdrant, Milvus, risk: lowFree
  • vector-index-tuningOptimize vector index performance for latency, recall, and memory. Use when tuning HNSW parameters, selecting quantization strategrisk: lowFree