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
RETURNINGclause - will cause syntax error - NO
ON CONFLICT- will fail (also: no UNIQUE constraints on name columns!) - Use
read_queryto 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.