Skip to content
cccskills

Browse skills

1.7K skills ・ Works with: PostgreSQL · sorted by popularity

Monitor public Certificate Transparency logs, which record TLS certificates, to spot unexpected issuance and discover subdomains. Use crt.sh data to maintain a certificate inventory, check domain findings against DNS, and configure alerts for suspicious activity.

  • Monitoring owned domains for unexpected certificate issuance
  • Discovering subdomains and checking their DNS records
  • Investigating certificates for look-alike domains
mukul975/Anthropic-Cybersecurity-Skills34.7KUpdated Aug 31, 2026

sql-pro

FreeSummary

Write complex SQL, improve slow queries, and design database schemas for transaction processing and analytics. Uses schema details and query execution plans to guide indexing, validate results, and assess performance with realistic data volumes.

  • Investigate and improve slow analytical queries
  • Design a database schema for a SaaS application
  • Write customer retention and cohort analysis queries
davila7/claude-code-templates32.8KUpdated Oct 20, 2026

cloud-sql-basics

FreeSummary

Create and manage MySQL, PostgreSQL, and SQL Server databases on Google Cloud. Covers instance setup, users, backups, availability, and secure connections, with a PostgreSQL walkthrough and references for application connectors and Terraform configuration.

  • Create a PostgreSQL database on Google Cloud
  • Manage database users and passwords
  • Connect through Cloud SQL Auth Proxy
davila7/claude-code-templates32.8KUpdated Oct 20, 2026

Design PostgreSQL tables by choosing data types, validation rules, and indexes that match actual queries. The skill also guides JSONB usage, partitioning large tables, and planning schema changes with attention to read and write workloads.

  • Designing tables for users and orders
  • Reviewing indexes against actual queries
  • Choosing between relational columns and JSONB
davila7/claude-code-templates32.8KUpdated Oct 20, 2026

Guides Postgres query writing, schema design, and configuration reviews using Supabase's prioritized rules. Helps identify improvements in query performance, connection management, and row-level security, which controls access to individual rows.

  • Review slow SQL queries and index usage
  • Check table and schema designs
  • Review connection pooling and scaling settings
davila7/claude-code-templates32.8KUpdated Oct 20, 2026

postgresql

FreeSummary

Design PostgreSQL tables around actual queries and data volumes. Choose data types, validation rules, and indexes, then plan large table partitioning, access rules for individual rows, and schema changes with migration and rollback considerations.

  • Designing tables for users, orders, and related data
  • Reviewing data types, constraints, and indexes
  • Planning large tables and frequent update workloads
davila7/claude-code-templates32.8KUpdated Oct 20, 2026

Design a database layer from business requirements, access patterns, and expected growth. Compare database technologies, define tables and relationships, and plan indexes, caching, scaling, migrations, backups, and recovery with clear reasons and trade-offs.

  • Choosing a database for a new service
  • Designing tables, relationships, and indexes
  • Planning database migrations and rollback procedures
davila7/claude-code-templates32.8KUpdated Oct 20, 2026

alloydb-basics

FreeSummary

Set up and manage AlloyDB for PostgreSQL clusters, instances, and backups. Includes guidance for MCP integration, a way for agents to operate databases, plus references for application connections, Terraform, authentication, and AI search capabilities.

  • Create an AlloyDB cluster and primary instance
  • Manage AlloyDB backups
  • Automate database operations through MCP
davila7/claude-code-templates32.8KUpdated Oct 20, 2026

neon-instagres

FreeSummary

Provision a PostgreSQL database with Neon Instagres and save connection settings for application use and migrations. Includes setup examples for Drizzle and Prisma, initial data loading, and claiming a temporary database to keep using it.

  • Provision a PostgreSQL database for development
  • Configure database access with Drizzle or Prisma
  • Load a SQL file with initial data
davila7/claude-code-templates32.8KUpdated Oct 20, 2026

Plan and implement database structure changes and data transfers using Sequelize, TypeORM, or Prisma. Covers staged changes to keep services running, rollback procedures to undo changes, backups, and migration verification.

  • Add, rename, or change database columns
  • Transform data into a new structure
  • Prepare and test rollback procedures
davila7/claude-code-templates32.8KUpdated Oct 20, 2026

Improve PostgreSQL performance through a staged workflow covering slow query analysis, indexes that speed up data access, query rewrites, configuration tuning, routine maintenance, and monitoring for production databases.

  • Investigating slow PostgreSQL queries
  • Reviewing database indexes
  • Tuning database configuration
davila7/claude-code-templates32.8KUpdated Oct 20, 2026

using-neon

FreeSummary

Guides development with Neon, a managed Postgres database platform, using official documentation. Covers project setup, connection choices, local development, authentication, data APIs, and resource management through command-line tools and programming libraries.

  • Set up a Neon project and database connection
  • Choose a connection method for serverless or edge functions
  • Integrate Neon authentication and data APIs
davila7/claude-code-templates32.8KUpdated Oct 20, 2026

Document major technical decisions with their context, alternatives, reasoning, and consequences. The skill provides Architecture Decision Record templates and maintenance practices so teams can review past choices, track replacements, and explain decisions to new members.

  • Recording reasons for technology choices
  • Comparing design options and trade-offs
  • Explaining past decisions to new team members
davila7/claude-code-templates32.8KUpdated Oct 20, 2026

c4-architecture

FreeSummary

Turn a codebase into architecture documentation with Mermaid diagrams. Using the C4 model, a way to describe systems at different levels of detail, the skill explains external relationships, applications, internal components, deployment, and request flows.

  • Explaining a system overview to stakeholders
  • Documenting relationships between apps and databases
  • Mapping internal components of a feature
davila7/claude-code-templates32.8KUpdated Oct 20, 2026

Improve resumes for software engineering, technical product management, data, and DevOps roles. Organize technical skills, connect achievements to business results, and highlight projects in a format suited to applicant tracking systems, software used to process job applications, and recruiters.

  • Organize technical skills for a target role
  • Rewrite experience to show technical and business impact
  • Choose projects to highlight during a career change
davila7/claude-code-templates32.8KUpdated Oct 20, 2026

perplexity

FreeSummary

Use Perplexity to find web resources, recent information, or clear explanations drawn from the web. The skill chooses between search results and conversational answers, while directing specialized documentation and workspace questions to other tools.

  • Finding recent information on a topic
  • Discovering tutorials and blog posts
  • Getting web-based explanations of concepts
davila7/claude-code-templates32.8KUpdated Oct 20, 2026

Use Phoenix to record execution traces, detailed records of an AI application's operations, and investigate problems. Evaluate answers on datasets, compare prompts and models, and set up monitoring through a self-hosted server.

  • Investigate AI application problems using execution traces
  • Evaluate answer quality across a test dataset
  • Compare prompts and models through experiments
davila7/claude-code-templates32.8KUpdated Oct 20, 2026

autogpt-agents

FreeSummary

Build and operate AutoGPT agents that carry out multi-step workflows. Covers a visual editor for connecting processing blocks, scheduled and webhook triggers, deployment, execution monitoring, and benchmarks for evaluating agent performance.

  • Build an AI workflow in a visual editor
  • Run agents on a schedule or external event
  • Add custom agent abilities with Forge
davila7/claude-code-templates32.8KUpdated Oct 20, 2026

Tune cognee ingestion speed, query response time, and LLM costs by adjusting concurrency, text chunk sizes, request limits, and model choices. Estimate ingestion costs before processing and assess options for background work and deployment scaling.

  • Estimating costs before importing documents
  • Adjusting ingestion speed and request limits
  • Reducing query response time
topoteretes/cognee32.6KUpdated Oct 20, 2026

Set up users, organizations, roles, and dataset sharing in cognee. The skill explains SDK and HTTP authentication, helps investigate permission errors or missing datasets, and clarifies how access settings separate each user’s stored data.

  • Share datasets with specific users or roles
  • Organize data access across teams and organizations
  • Configure SDK identities and HTTP authentication
topoteretes/cognee32.6KUpdated Oct 20, 2026

cognee-docker

FreeSummary

Run cognee in Docker, starting with a prebuilt image for local document ingestion and questions. It also covers Docker Compose profiles for adding the UI, MCP server, Postgres, and Neo4j, plus persistent data storage.

  • Try cognee locally using a prebuilt Docker image
  • Test document ingestion and questions through the API
  • Start the UI, MCP server, and databases with Docker Compose
topoteretes/cognee32.6KUpdated Oct 20, 2026

Manage cognee database migrations, from checking migration status and recovering blocked writes to creating schema or data updates. It also guides dataset backups, restores, and transfers using cognee’s portable COGX archive format.

  • Recover writes blocked by a failed migration
  • Create migrations for database structure or stored data
  • Back up and restore datasets with COGX
topoteretes/cognee32.6KUpdated Oct 20, 2026

Connect cognee to model providers, databases, storage services, and development tools. Guides configuration of language models and embeddings, the numerical representations used for search, including the separate settings each requires.

  • Switching model providers or using Ollama locally
  • Connecting cognee to Postgres or Neo4j
  • Storing cognee data in S3
topoteretes/cognee32.6KUpdated Oct 20, 2026

postgres-adopt

FreeSummary

Check whether gbrain uses PGLite or Postgres, set up a Postgres-backed installation, or migrate existing PGLite data with its history. The workflow presents a migration plan for approval, verifies transferred tables, and supports interrupted migration recovery.

  • Checking which database engine gbrain uses
  • Setting up Postgres for a new gbrain installation
  • Moving PGLite data and history to Postgres
garrytan/gbrain31KUpdated Oct 19, 2026