Topic: sql
73 skills in this topic.
-
git-expert
Git expert with deep knowledge of merge conflicts, branching strategies, repository recovery, performance optimization, and security patterns. Use PROACTIVELY for any Git workflow issues including complex merge conflicts, history rewriting, collaboration patterns, and repository management. If a specialized expert is a better fit, I will recommend switching and stop.
cin12211/orca-q 100
-
github-actions-expert
GitHub Actions CI/CD pipeline optimization, workflow automation, custom actions development, and security best practices for scalable software delivery
cin12211/orca-q 100
-
mongodb-expert
MongoDB document modeling, aggregation pipeline optimization, sharding strategies, replica set configuration, connection pool management, and indexing patterns. Use this skill for MongoDB-specific issues, NoSQL performance optimization, and schema design.
cin12211/orca-q 100
-
jest-testing-expert
Expert in Jest testing framework, advanced mocking strategies, snapshot testing, async patterns, TypeScript integration, and performance optimization
cin12211/orca-q 100
-
testing-expert
Testing expert with comprehensive knowledge of test structure, mocking strategies, async testing, coverage analysis, and cross-framework debugging. Use PROACTIVELY for test reliability, flaky test debugging, framework migration, and testing architecture decisions. Covers Jest, Vitest, Playwright, and Testing Library.
cin12211/orca-q 100
-
rest-api-expert
REST API design and development expert specializing in endpoint design, HTTP semantics, versioning, error handling, pagination, and OpenAPI documentation. Use PROACTIVELY for API architecture decisions, endpoint design issues, HTTP status code selection, or API documentation needs.
cin12211/orca-q 100
-
research-expert
Specialized research expert for parallel information gathering. Use for focused research tasks with clear objectives and structured output requirements.
cin12211/orca-q 100
-
refactoring-expert
Expert in systematic code refactoring, code smell detection, and structural optimization. Use PROACTIVELY when encountering duplicated code, long methods, complex conditionals, or any code quality issues. Detects code smells and applies proven refactoring techniques without changing external behavior.
cin12211/orca-q 100
-
postgres-expert
PostgreSQL query optimization, JSONB operations, advanced indexing strategies, partitioning, connection management, and database administration. Use this skill for PostgreSQL-specific optimizations, performance tuning, replication setup, and PgBouncer configuration.
cin12211/orca-q 100
-
playwright-expert
Playwright E2E testing expert for browser automation, cross-browser testing, visual regression, network interception, and CI integration. Use for E2E test setup, flaky tests, or browser automation challenges.
cin12211/orca-q 100
-
nodejs-expert
Node.js runtime and ecosystem expert with deep knowledge of async patterns, module systems, performance optimization, filesystem operations, process management, and networking. Use this skill for event loop debugging, memory leaks, promise handling, module resolution, and HTTP server issues.
cin12211/orca-q 100
-
nextjs-expert
Next.js framework expert specializing in App Router, Server Components, performance optimization, data fetching patterns, and full-stack development. Use this skill for Next.js routing issues, hydration errors, build problems, or deployment challenges.
cin12211/orca-q 100
-
nestjs-expert
Nest.js framework expert specializing in module architecture, dependency injection, middleware, guards, interceptors, testing with Jest/Supertest, TypeORM/Mongoose integration, and Passport.js authentication. Use PROACTIVELY for any Nest.js application issues including architecture decisions, testing strategies, performance optimization, or debugging complex dependency injection problems. If a specialized expert is a better fit, I will recommend switching and stop.
cin12211/orca-q 100
-
cdc
Change Data Capture - architecture, entrypoints, bytecode emission, sync engine integration, tests
tursodatabase/turso 18,059
-
code-quality
General Correctness rules, Rust patterns, comments, avoiding over-engineering. When writing code always take these into account
tursodatabase/turso 18,059
-
debugging
How to debug tursodb using Bytecode comparison, logging, ThreadSanitizer, deterministic simulation, and corruption analysis tools
tursodatabase/turso 18,059
-
differential-fuzzer
Information about the differential fuzzer tool, how to run it and use it catch bugs in Turso. Always load this skill when running this tool
tursodatabase/turso 18,059
-
index-knowledge
Generate hierarchical AGENTS.md knowledge base for a codebase. Creates root + complexity-scored subdirectory documentation.
tursodatabase/turso 18,059
-
memory-benchmark
How to benchmark and analyze memory usage in Turso using the memory-benchmark crate and dhat heap profiler. Use this skill whenever the user mentions memory usage, memory profiling, allocation tracking, heap analysis, memory regression, memory benchmarking, dhat, or wants to understand where memory is being allocated during SQL workloads. Also use when investigating memory growth in WAL or MVCC mode. IMPORTANT - If you modify the perf/memory crate (add profiles, change CLI flags, change output format, etc.), update this skill document to reflect those changes so it stays accurate for future agents.
tursodatabase/turso 18,059
-
mvcc
Overview of Experimental MVCC feature - snapshot isolation, versioning, limitations
tursodatabase/turso 18,059
-
pr-workflow
General guidelines for Commits, formatting, CI, dependencies, security
tursodatabase/turso 18,059
-
storage-format
SQLite file format, B-trees, pages, cells, overflow, freelist that is used in tursodb
tursodatabase/turso 18,059
-
testing
How to write tests, when to use each type of test, and how to run them. Contains information about conversion of `.test` to `.sqltest`, and how to write `.sqltest` and rust tests
tursodatabase/turso 18,059
-
transaction-correctness
How WAL mechanics, checkpointing, concurrency rules, recovery work in tursodb
tursodatabase/turso 18,059