1.7K skills ・ Works with: PostgreSQL · sorted by popularity
Explore development ideas and problems through conversation, code investigation, diagrams, and comparisons. The skill helps clarify requirements, weigh approaches, and surface risks before or during a change, with optional documentation of decisions when requested.
Turn everyday questions into SQL queries, the commands used to retrieve and summarize database records. Uses your database structure and platform to produce queries with explanations, performance notes, and optional validation scripts.
Design n8n automations for incoming events, API connections, database synchronization, AI agents, scheduled tasks, and batch processing. Choose a suitable structure, plan error handling, check connections, test results, and review performance when processing large numbers of items.
Deploy n8n on a Linux server using Docker Compose and Caddy for automatic HTTPS. Covers single-instance setups, workers for parallel execution, secret management, deployment checks, updates, backups, and restoration.
Write and troubleshoot n8n expressions, the formulas that pass and transform data between workflow steps. Covers field references, webhook inputs, dates, strings, and choosing between expressions and Code nodes for data transformations.
Get documentation-based help with PostgreSQL queries, database design, administration, and performance tuning. The supplied reference also explains connection settings and libpq, PostgreSQL’s C client library, for investigating connection failures and implementing connection handling.
Develop time-series and event-data solutions with TimescaleDB, an extension for PostgreSQL. The skill provides organized references for installation, time-based tables, ongoing aggregate calculations, compression, and performance troubleshooting.
Plan and manage Cloud Spanner databases on Google Cloud, design tables and primary keys, write SQL and client code, and investigate slow queries using database statistics to identify resource-intensive operations.
Design and implement Google Cloud serverless web apps with separate presentation, application, and data layers. Produces architecture diagrams, Terraform infrastructure code, deployment instructions, and validation scripts for private networking and controlled access between layers.
Create and connect to managed MySQL, PostgreSQL, or SQL Server databases on Google Cloud. This skill guides instance setup, database creation, access permissions, and connection steps, with references for backups, security, and Terraform configuration.
Create and administer AlloyDB for PostgreSQL databases, including clusters, instances, backups, secure connections, and access permissions. It also covers command-line operations, infrastructure configuration, and MCP tools that let agents automate database tasks.
Manage separate local development environments for multiple branches using the project's pnpm worktree CLI. Each environment has its own ports and dependencies, with options to share Supabase or isolate database changes for testing.
Verify Kortix changes with focused tests and real inputs and outputs. This skill guides test placement, API and CLI workflows, browser checks, database verification, and reporting of results, including skipped cases.
Check new customer onboarding progress using HubSpot and Postgres, identify stalled or overdue milestones, and prepare emails tailored to the missed step. Notify the customer success manager while leaving customer communication to human review.
Prepare quarterly business reviews using account records from HubSpot and usage trends from Postgres. Create a draft slide deck and supporting document for each due account, with traceable figures, support issues, and evidence-backed expansion opportunities.
Create weekly reports from Postgres metrics, comparing current figures with recent weeks. Add plain-language explanations for notable changes, flag missing data, and post one report to Slack while keeping database access read-only.
Draft monthly investor updates from Stripe, Postgres, and the previous report. Compare revenue, recurring subscription revenue, account activity, cash burn, and runway against last month and plan, then create a new document for the founder to review.
Manage encrypted API secrets across local, development, staging, and production profiles with dotenvx and Dotenv Armor. Covers storing and rotating credentials, sharing decryption keys, selecting runtime environments, and checking profile consistency with deployed AWS Secrets Manager settings.
Prepares reports for GDPR personal data access or deletion requests. Checks Gmail, verifies identity, searches related Postgres records without changing them, and creates a Google Doc for legal review, leaving deletion and requester replies to people.
Combine product usage, support issues, payment status, and renewal dates to rank accounts by churn risk, meaning the risk of cancellation. Produce a Slack list with specific evidence and a suggested next action for each account.
Develop and debug LangBot's backend and web frontend. The skill guides environment setup, API additions, authentication, database migrations, and testing, including updates to matching MCP tools so agents can use changed API features.
Write, debug, and optimize SQL queries for data analysis and database design. The skill covers aggregations, rankings, missing values, and indexes, using execution plans to understand performance and adapting syntax to the database in use.
Improve PostgreSQL queries and database design by examining execution plans and choosing indexes for actual access patterns. Get guidance on large tables, JSONB data, connection pooling, and maintenance while accounting for write overhead and memory use.
Guide secret synchronization between Infisical and a local encrypted vault, a store for sensitive values such as API keys. Covers authentication, reading and updating secrets, change tracking, and troubleshooting without exposing values in logs.