Can I simulate payments without an external provider?

Yes, the skill includes specific workflows to update organization and opportunity flags to mock active Paddle subscriptions locally, allowing for end-to-end testing of subscription logic.

What should I do if I am unsure of the database schema?

The skill includes schema discovery techniques such as checking TypeORM entity definitions in the source code and searching for enum definitions in the @dailydotdev/schema package.

How does this skill help with local database queries?

It automatically identifies the correct PostgreSQL container within your local Docker or Kubernetes environment and handles the execution of both single and multi-line SQL queries without manual container lookups.

How do I change the status of a recruitment opportunity?

The skill provides pre-defined commands to update the integer-based state column for opportunities, allowing you to move them between Draft (1), Live (2), Closed (3), and In-Review (4) statuses instantly.

Local Environment Manager

Name: Local Environment Manager
Author: dailydotdev

bydailydotdev

•

463

Database Management

Manages local database operations, test data setup, and Docker-based environment configurations for the daily-api service.

About

This skill streamlines local development for the daily-api repository by providing automated workflows for PostgreSQL database management within Docker and Kubernetes containers. It enables developers to quickly locate database containers, execute complex SQL queries, and manage application-specific states such as fake payment subscriptions and recruitment opportunity lifecycles. By handling the nuances of JSONB fields, integer enums, and TypeORM entity mapping, it ensures high consistency and speed during test data preparation and environment troubleshooting.

Key Features

Standardized data reset procedures for maintaining clean local testing environments
Lifecycle state management for recruitment opportunities (Draft, Live, Closed, In-Review)
Sophisticated fake payment simulation for organizations and recruitment opportunities
463 GitHub stars
Automated PostgreSQL container identification and SQL execution via Docker
Schema discovery tools for identifying TypeORM entities and enum values

Use Cases

Transitioning recruitment opportunities between lifecycle states for local debugging
Simulating active recruiter subscriptions to test premium paywalled features
Investigating complex database schemas and nested JSONB column structures

About

Key Features

Standardized data reset procedures for maintaining clean local testing environments
Lifecycle state management for recruitment opportunities (Draft, Live, Closed, In-Review)
Sophisticated fake payment simulation for organizations and recruitment opportunities
463 GitHub stars
Automated PostgreSQL container identification and SQL execution via Docker
Schema discovery tools for identifying TypeORM entities and enum values

Use Cases

Transitioning recruitment opportunities between lifecycle states for local debugging
Simulating active recruiter subscriptions to test premium paywalled features
Investigating complex database schemas and nested JSONB column structures