- Home
- /
- Categories
- /
- Database
Database
Database management and queries
skills
by ThePrimeagen
skills
by ThePrimeagen
Follow a safe rollout flow: apply bun run db:migrate:local first, validate locally, commit schema + generated migrations together, then apply bun run db:migrate:remote for Cloudflare-connected environments.
lseg-data
by edwinhu
This skill should be used when the user asks to “access LSEG data”, “query Refinitiv”, “get market data from Refinitiv”, “download fundamentals from LSEG”, “access ESG scores”, “convert RIC to ISIN”, “get shareholder activism data”, “query poison pills”, “access corporate governance data”, “find activist campaigns”, “get syndicated loans data”, “query loan deals”, “get infrastructure projects”, “query project finance data”, “get private equity data”, “query VC investments”, “find PE-backed companies”, “get M&A data”, “query mergers and acquisitions”, “find acquisition deals”, “get IPO data”, “query equity offerings”, “find new issues”, “get joint venture data”, “query strategic alliances”, “get news headlines”, “query news data”, “fetch news articles”, or needs the LSEG Data Library Python API.
data-context
by edwinhu
"This skill should be used when the user asks to 'set up data analysis for our database', 'extract tribal knowledge about dataset', 'generate data skill', 'document this dataset', 'what does this column mean', 'create data dictionary', 'help me understand this data schema', 'capture domain knowledge about our data', or needs to create a reusable data context skill from dataset expertise."
legacy-bridge
by williamzujkowski
Backward compatibility bridge that translates legacy @load patterns to new Skills format. Enables seamless migration with zero breaking changes during 6-month transition period.
kotlin-coding-standards
by williamzujkowski
Master Kotlin coding standards with null safety, coroutines, and idiomatic patterns. Use when developing JVM/Android applications requiring type-safe async programming.
data-quality
by williamzujkowski
'Core Principles:'
sql
by williamzujkowski
Sql standards for sql in Database environments. Covers best practices,
nosql
by williamzujkowski
Nosql standards for nosql in Database environments. Covers best practices,
iterate-plan
by mhylle
Update existing implementation plans through user feedback with thorough research and validation. Also migrates old checkbox-based plans to the new Task tools system. This skill should be used when iterating on implementation plans, updating plans based on new requirements, refining technical approaches in existing plans, migrating old plans to Task tools, or when the user wants to modify a previously created plan file. Triggers on requests like "update the plan", "change the implementation approach", "iterate on this plan", "migrate to new system", or when feedback is provided about an existing plan document.
wrds
by edwinhu
This skill should be used when the user asks to "query WRDS", "access Compustat", "get CRSP data", "pull Form 4 insider data", "query ISS compensation", "download SEC EDGAR filings", "get ExecuComp data", "access Capital IQ", "write SAS code for WRDS", "SAS ETL", "SAS hash merge", "SGE array job", "qsas", "qsub SAS", or needs WRDS PostgreSQL query patterns or SAS ETL performance patterns.
acsets-relational-thinking
by plurigrid
ACSets (Attributed C-Sets) for categorical database design and DPO rewriting
acsets-algebraic-databases
by plurigrid
"ACSets (Attributed C-Sets): Algebraic databases with Specter-style bidirectional"
2600-magazine
by plurigrid
Query and explore the 2600: The Hacker Quarterly magazine archive (1984-present) via DuckDB. Provides structured access to 168+ issues covering hacker culture, security, privacy, telephony, and digital rights without loading full content into context.
69-constructions Skill
by plurigrid
Add Interaction Exemplars here as the skill is used.
acsets-algebraic-databases
by plurigrid
"ACSets (Attributed C-Sets): Algebraic databases with Specter-style bidirectional navigation. Category-theoretic formalism for relational databases."
active-interleave
by plurigrid
Interleaves context from recently active Claude/Amp threads into current activity via random walk.
acset-taxonomy
by plurigrid
Taxonomy of ACSet skills with morphisms to semantically similar categorical/relational skills
wp-phpstan
by Automattic
"Use when configuring, running, or fixing PHPStan static analysis in WordPress projects (plugins/themes/sites): phpstan.neon setup, baselines, WordPress-specific typing, and handling third-party plugin classes."
sql-query-optimizer
by organvm-iv-taxis
Analyzes complex SQL queries to improve performance, suggesting indexing strategies, schema refactoring, and query rewrites.
aws-solution-architect
by alirezarezvani
Expert AWS solution architecture for startups focusing on serverless, scalable, and cost-effective cloud infrastructure with modern DevOps practices and infrastructure-as-code
tech-stack-evaluator
by alirezarezvani
Comprehensive technology stack evaluation and comparison tool with TCO analysis, security assessment, and intelligent recommendations for engineering teams
convex-best-practices
by waynesutton
Guidelines for building production-ready Convex apps covering function organization, query patterns, validation, TypeScript usage, error handling, and the Zen of Convex design philosophy
arkts-syntax-assistant
by SummerKaze
ArkTS syntax, migration, and optimization guide for HarmonyOS/OpenHarmony development. Triggers on: .ets files, ArkTS keywords, HarmonyOS/OpenHarmony context, @ohos packages. Help with syntax reference, TypeScript migration, performance optimization, compile errors, state management, component development, and language-specific questions.