Postgres Patterns
Helps with PostgreSQL, patterns as part of working with databases and data persistence workflows.
Install on your platform
We auto-selected Claude Code based on this skill’s supported platforms.
Run in terminal (recommended)
claude mcp add ashfaqbs-postgres-patterns npx -- -y @trustedskills/ashfaqbs-postgres-patterns
Or manually add to ~/.claude/settings.json
{
"mcpServers": {
"ashfaqbs-postgres-patterns": {
"command": "npx",
"args": [
"-y",
"@trustedskills/ashfaqbs-postgres-patterns"
]
}
}
}Requires Claude Code (claude CLI). Run claude --version to verify your install.
About This Skill
What it does
This skill provides access to PostgreSQL patterns, allowing for advanced text searching and manipulation within database queries. It enables the extraction of specific data based on complex string matching rules using pattern matching operators like ~, !~, SIMILAR TO, and NOT SIMILAR TO. This is particularly useful when dealing with unstructured or semi-structured data stored in PostgreSQL databases.
When to use it
- Extracting email addresses from a text field containing customer feedback.
- Identifying records where product descriptions contain specific keywords or phrases using regular expressions.
- Filtering log entries based on patterns found within timestamped messages.
- Analyzing user-generated content for sentiment analysis by identifying key phrases and their associated meanings.
Key capabilities
~: Matches a string against a regular expression pattern.!~: Does not match a string against a regular expression pattern.SIMILAR TO: Matches a string against a SQL-standard pattern.NOT SIMILAR TO: Does not match a string against a SQL-standard pattern.
Example prompts
- "Find all customer names in the 'customers' table where their name matches the pattern '^[A-Z][a-z]+ [A-Z][a-z]+$'."
- "Extract all email addresses from the 'feedback' column in the 'reviews' table using a regular expression."
- “Show me records from the ‘logs’ table where the message starts with ‘ERROR’ and contains a timestamp.”
Tips & gotchas
- Requires familiarity with PostgreSQL query syntax and regular expressions.
- Complex patterns can impact query performance; optimize them carefully for large datasets.
Tags
TrustedSkills Verification
Unlike other registries that point to live repositories, TrustedSkills pins every skill to a verified commit hash. This protects you from malicious updates — what you install today is exactly what was reviewed and verified.
Security Audits
| Gen Agent Trust Hub | Pass |
| Socket | Pass |
| Snyk | Pass |
🌐 Community
Passed automated security scans.