bel-crm-schema-write-db

Installation
SKILL.md

BEL CRM Schema Write DB

CRITICAL: Read SQL Rules First!

Before writing ANY SQL, consult the bel-crm-sql-rules skill!

Key limitations of the PostgreSQL MCP server:

  • NO RETURNING clause - will cause syntax error
  • NO ON CONFLICT - will fail (also: no UNIQUE constraints on name columns!)
  • Use read_query to get IDs after INSERT

Overview

This skill provides comprehensive knowledge of the CRM PostgreSQL database schema and generates correct, PostgreSQL-specific SQL queries for managing companies, contacts, sales opportunities, and activity events.

The CRM database uses a relational model with JSONB fields for flexible tagging and metadata, temporal tracking with timestamps, and foreign key relationships between companies, people, opportunities, and events.

When to Use This Skill

Installs
1
GitHub Stars
2
First Seen
10 days ago