postgres-best-practices
π―Skillfrom dirnbauer/webconsulting-skills
Provides expert guidance and automated recommendations for optimizing PostgreSQL database performance, security, and configuration best practices.
Installation
npx skills add https://github.com/dirnbauer/webconsulting-skills --skill postgres-best-practicesSkill Details
Overview
# webconsulting skills - Claude Marketplace
A curated collection of Agent Skills for AI-augmented software development. These skills transform Claude into a specialized assistant for web development, video creation, security auditing, and enterprise software engineering.
> Works with: Claude Code, Cursor IDE (tested with Cursor 2.2+)
Skill Categories
| Category | Skills | Description |
|----------|--------|-------------|
| TYPO3 CMS | 12 skills | Content Blocks, DataHandler, upgrades, testing, security |
| Video & Animation | 1 skill | Remotion video creation in React |
| Security & Enterprise | 3 skills | OWASP audits, OpenSSF Scorecard, supply chain security |
| Database | 1 skill | Postgres performance, RLS, indexes, connection pooling (Supabase) |
| Marketing | 1 skill | CRO, copywriting, SEO, pricing, psychology (Corey Haines) |
| PHP & Tools | 3 skills | PHP 8.x modernization, CLI tools, documentation lookup |
| Frontend & Design | 2 skills | UI patterns, design systems, accessibility |
| Legal & Compliance | 4 skills | Impressum (AT, DE, EU, international) |
| AI & SEO | 1 skill | AEO/GEO for AI search visibility |
---
> ## π’ Early Adopter Notice
>
> We encourage you to use these skills! They're designed to boost your TYPO3 productivity significantly.
> However, please keep these points in mind:
>
> - Evolving Technology β Anthropic, Cursor, and webconsulting are actively improving their platforms. Expect updates and occasional breaking changes.
> - Review AI Output β Always review AI-generated code before committing. These skills enhance productivity, but human judgment remains essential.
> - Stay Updated β Run git pull && ./install.sh regularly to get the latest improvements and compatibility fixes.
>
> Questions or feedback? We'd love to hear from you!
---
> Attribution: The majority of skills in this repository are derived from the excellent work by
> [Netresearch DTT GmbH](https://github.com/netresearch). We recommend using their original
> repositories for the latest updates. A few additional skills are specific to webconsulting.at.
---
π Unified Agent Skills (Cursor + Claude Code)
Both Cursor and Claude Code now share the same skills location: ~/.claude/skills/
What's New
| Feature | Description |
|---------|-------------|
| Unified Location | Skills install to ~/.claude/skills/ (works for Cursor & Claude Code) |
| Auto-Discovery | Both IDEs automatically find and load skills |
| Invoke with / | Type / in Agent chat to see all available skills |
| Cross-Platform | Same skills work in Cursor, Claude Code, and Claude CLI |
Directory Structure After Install
```
~/.claude/skills/ β Primary (shared by Cursor & Claude Code)
βββ typo3-content-blocks/
βββ typo3-datahandler/
βββ ...
.cursor/
βββ skills/ β Project-level (version-controlled)
βββ rules/ β Legacy .mdc files (backwards compat)
```
Using Skills
In Cursor:
- Auto-applied: Cursor decides when skills are relevant
- Manual invoke: Type
/typo3-content-blocksin Agent chat - View all: Go to
Cursor Settings β Rulesto see discovered skills
In Claude Code:
- Skills are automatically loaded from
~/.claude/skills/ - Reference skills in your prompts or let Claude auto-detect
> Note: Legacy .mdc rules are still generated in .cursor/rules/ for backwards compatibility.
---
Quick Start
Option 1: Standalone Installation (Recommended)
```bash
# Clone the repository
git clone git@github.com:dirnbauer/webconsulting-skills.git
cd webconsulting-skills
# Install skills
chmod +x install.sh
./install.sh
# Restart Cursor IDE or Claude Code
```
Option 2: Clone as Project Subdirectory
```bash
# From your project root
git clone git@github.com:dirnbauer/webconsulting-skills.git webconsulting-skills
# Install skills (auto-detects parent project)
cd
More from this repository10
typo3-seo skill from dirnbauer/webconsulting-skills
typo3-content-blocks skill from dirnbauer/webconsulting-skills
Assists TYPO3 developers in systematically upgrading extensions by analyzing compatibility, suggesting code modifications, and generating migration scripts for version transitions.
Assists TYPO3 core developers in creating, reviewing, and preparing high-quality code contributions by providing automated guidance on TYPO3 coding standards, extension development best practices, ...
Automatically refactors and modernizes TYPO3 PHP code using Rector, helping developers upgrade legacy code and apply best practices with minimal manual intervention.
Automates TYPO3 CMS version upgrades, providing step-by-step guidance and code generation for safely migrating between TYPO3 versions while handling potential compatibility issues and extension upd...
Automates TYPO3 development environment setup and configuration using DDEV, streamlining local development workflows for TYPO3 projects.
Generates legally compliant impressum (website legal notice) templates for Austrian, German, European, and international websites, ensuring proper legal disclosure requirements are met.
Detects and analyzes potential deepfake images or videos by applying advanced machine learning algorithms to identify signs of AI-generated media manipulation.
Optimizes AI-generated content for improved search engine visibility and ranking through advanced SEO and AI-driven search strategies.