Delegate independent tasks to specialized agents working concurrently with isolated context.
295.4K 206.3K
View 
Building hypothetical indexes
hypopg-help
used for preparing hypothetical indexes to be run in higher environments
SKILL.md
Full skill instructions
Building hypothetical indexes
Useful when a database includes the hypopg extension (for Postgres) to create and test hypothetical indexes. The goal is to create a copy and pasteable set of commands that a user can run to create a hypothetical index for testing in a higher environment.
The final deliverable is a set of Ruby commands to copy/paste. Wrap them in code blocks.
Instructions
- Work with the user to determine the index design. Ask them about contents, which table, and any ordering or conditional concerns.
- Use
connection = ::ActiveRecord::Base.lease_connectionto find an available connection - Create a temporary variable called
create_index_sqlusing a<<~SQL.squishheredoc for the index creation. - Next, use string interpolation to create a new SQL string to create the hypopg index using
hypopg_create_index(). Set this tohypopg_sql. Useconnection.quote(create_index_sql)to properly handle nested quotes and SQL escaping when interpolating the SQL string into the hypopg function call - Provide the snippet for the end user to use
connection.execute hypopg_sql. The result should be saved toresultsand we should instruct the user to outputresults.to_a. - To verify the hypothetical index is being used, instruct the user to use the same
connectionto call.executewith string interpolation to add "EXPLAIN " at the beginning of a#to_sqlcall on a chain of model code. For example:connection.execute("EXPLAIN #{Model.where(...).to_sql}"). - Provide follow-up instructions to the user on how to verify the new hypothetical index is being used. Provide context on how to clean up new hypothetical indexes if they need to try an alternative.
More Other skills
Other
brand-guidelines
Applies Anthropic's official brand colors and typography to any sort of artifact that may benefit from having Anthropic's look-and-feel. Use it when brand colors or style guidelines, visual formatting, or company design standards apply.
179.7K 100.1K
View Other
theme-factory
Toolkit for styling artifacts with a theme. These artifacts can be slides, docs, reportings, HTML landing pages, etc. There are 10 pre-set themes with colors/fonts that you can apply to any artifact that has been creating, or can generate a new theme on-the-fly.
179.7K 89.5K
View Other
internal-comms
A set of resources to help me write all kinds of internal communications, using the formats that my company likes to use. Claude should use this skill whenever asked to write some sort of internal communications (status reports, leadership updates, 3P updates, company newsletters, FAQs, incident reports, project updates, etc.).
179.7K 76.1K
View Fundamental design principles for writing maintainable, testable Python code.
40.2K 21.9K
View 
Other
responsive-design
Modern responsive layouts using container queries, fluid typography, CSS Grid, and mobile-first strategies.
40.2K 20K
View Generate Playwright tests from scenarios using interactive browser exploration and validation.
39.7K 18.2K
View Automated website exploration and test case generation using Playwright.
39.7K 14.9K
View Modern React state management with Redux Toolkit, Zustand, Jotai, and React Query for every state category.
40.2K 14.7K
View Other
gdpr-data-handling
GDPR-compliant data handling with consent management, data subject rights, and privacy controls.
40.2K 14.3K
View Python error handling patterns including input validation, exception hierarchies, and partial failure handling. Use when implementing validation logic, designing exception strategies, handling batch processing failures, or building robust APIs.
40.2K 13.5K
View 
Other
refactor-plan
Detailed multi-file refactor planning with safety checks and rollback guidance.
39.7K 13K
View