local-env
Helper tool for interacting with local Docker-based PostgreSQL databases and configuring subscription data.
Install
mkdir -p .claude/skills/local-env && curl -L -o skill.zip "https://agentskills.codes/api/skills/download/5674" && unzip -o skill.zip -d .claude/skills/local-env && rm skill.zipInstalls to .claude/skills/local-env
Activation
This is the description your AI agent reads to decide when to run this skill — the better it matches your request, the more reliably it fires.
Local environment management - run SQL queries, set up fake payments, reset test data. Use when the user needs help with local database operations or test data setup.Key capabilities
- →Execute SQL queries on a local PostgreSQL database
- →Set up fake payment statuses for organizations
- →Set up fake payment statuses for opportunities
- →Reset fake payment data for organizations and opportunities
- →Update the lifecycle state of an opportunity
- →Discover schema information for unknown database operations
How it works
The skill interacts with a local PostgreSQL database running in a Docker container. It executes SQL commands to manage test data, including setting fake payment statuses and updating opportunity states.
Inputs & outputs
When to use local-env
- →Execute SQL queries on local PostgreSQL
- →Set up fake subscription and payment status
- →Reset local test data
- →Verify organization subscription flags
About local-env
Simplifies management of local dev environments by executing SQL queries on Docker-hosted PostgreSQL containers. Includes commands to inject fake payment records for feature testing.
Local environment management - run SQL queries, set up fake payments, reset test data. Use when the user needs help with local database operations or test data setup.
When not to use it
- →When the database is not PostgreSQL or not running locally via Docker
- →When managing production environments or non-local databases
Prerequisites
Limitations
- →The skill is designed for local development environments.
- →Column naming in entity property names may differ from actual database columns.
- →Many status fields are integer enums, not strings.
How it compares
This skill automates common local development database tasks and test data setup using predefined SQL commands, which is more efficient than manually constructing and executing queries.
Compared to similar skills
local-env side by side with the closest alternatives in the catalog.
| Skill | Installs | Updated | Safety | Difficulty |
|---|---|---|---|---|
| local-env (this skill) | 1 | 8mo | Review | Beginner |
| supabase-local-dev-loop | 0 | 2mo | Caution | Beginner |
| test-with-postgres | 1 | 4mo | Review | Intermediate |
| supabase-multi-env-setup | 1 | 2mo | Review | Advanced |
Try saying
Example prompts that trigger this skill in your AI assistant.
More by dailydotdev
View all by dailydotdev →You might also like
supabase-local-dev-loop
jeremylongshore
Configure Supabase local development with hot reload and testing. Use when setting up a development environment, configuring test workflows, or establishing a fast iteration cycle with Supabase. Trigger with phrases like "supabase dev setup", "supabase local development", "supabase dev environment", "develop with supabase".
test-with-postgres
storj
Run unit tests that require PostgreSQL. Use this skill when the user wants to run tests with PostgreSQL database backend. Automatically handles checking for and configuring a PostgreSQL Docker container.
supabase-multi-env-setup
jeremylongshore
Configure Supabase across development, staging, and production environments. Use when setting up multi-environment deployments, configuring per-environment secrets, or implementing environment-specific Supabase configurations. Trigger with phrases like "supabase environments", "supabase staging", "supabase dev prod", "supabase environment setup", "supabase config by env".
manage-infra
jpmolinamatute
Starts or stops the Docker Compose infrastructure (Postgres 17).
drizzle-orm
EpicenterHQ
Drizzle ORM patterns for type branding and custom types. Use when working with Drizzle column definitions, branded types, or custom type conversions.
database-design
davila7
Database design principles and decision-making. Schema design, indexing strategy, ORM selection, serverless databases.