local-database

Manage local PostgreSQL lifecycle and synchronization for the Teqo platform.

Updated Jul 31, 2026
One-click install
npx skills add https://github.com/fsolla/teqo --skill local-database
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: local-database
Source: https://github.com/fsolla/teqo/tree/main/.cursor/skills/local-database
Command: npx skills add https://github.com/fsolla/teqo --skill local-database

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) components.

What problem does it solve?

This skill prevents accidental connection to production Neon databases during local development and testing, ensuring that developers can safely refresh, seed, and troubleshoot their local Postgres environment without risking real citizen data.

Core Features & Use Cases

  • Safety Guardrails: Automatically blocks connections to non-local database hosts and enforces strict environment variable usage.
  • Database Refresh: Synchronizes local development environments with production content using secure, PII-excluded data pulls.
  • Content Seeding: Populates local databases with real-world news content and election data for realistic testing scenarios.

Quick Start

Run the local-database skill to start the Docker container and refresh the local database with production content.

Frequently Asked Questions about local-database

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I safely manage a local PostgreSQL database without accidentally connecting to production Neon environments?

To manage a local PostgreSQL database safely, use automated guardrails that block connections to non-local hosts and enforce strict environment variable usage, preventing accidental writes to production Neon environments.

How do I seed a local Postgres database with realistic content for development?

Seed a local Postgres database by running idempotent scripts that populate the environment with real-world news content and election data, providing realistic datasets for development and testing scenarios.

Can I synchronize a local development database with production data while protecting PII?

Yes, you can synchronize a local development database by pulling production content while enforcing strict PII exclusion, ensuring sensitive citizen data remains protected during the local refresh process.

Does the local database lifecycle management work with Docker containers?

Database lifecycle management supports Docker by starting containers to host the local Postgres instances, isolating the development environment from production Neon hosts through automated environment configuration.

Why do I need environment variable guardrails for local Postgres development?

Environment variable guardrails are needed for local Postgres development to automatically block connections to non-local database hosts, ensuring that schema management and troubleshooting never risk real citizen data.