{
  "id": "lib-skill:web-development--postgresql",
  "_kind": "LibrarySkill",
  "_file": "generated-library/skills.yaml",
  "_cluster": "generated-library",
  "attributes": {
    "displayName": "postgresql",
    "description": "PostgreSQL query optimization, indexing, full-text search, JSONB, and advanced features.",
    "libraryPath": "library/specializations/web-development/skills/postgresql/SKILL.md",
    "specialization": "web-development",
    "contentSummary": "# PostgreSQL Skill\n\nExpert assistance for PostgreSQL database design and optimization.\n\n## Capabilities\n\n- Design optimal schemas\n- Create performant indexes\n- Implement full-text search\n- Work with JSONB data\n- Optimize query performance\n- Configure replication\n\n## Indexing Patterns\n\n"
  },
  "outgoingEdges": [
    {
      "from": "lib-skill:web-development--postgresql",
      "to": "skill-area:backend-data-persistence",
      "kind": "lib_requires_skill_area",
      "attributes": {
        "weight": 1
      }
    },
    {
      "from": "lib-skill:web-development--postgresql",
      "to": "skill-area:database-migrations-zero-downtime",
      "kind": "lib_requires_skill_area",
      "attributes": {
        "weight": 0.7
      }
    },
    {
      "from": "lib-skill:web-development--postgresql",
      "to": "topic:database-sharding",
      "kind": "lib_covers_topic",
      "attributes": {
        "weight": 1
      }
    },
    {
      "from": "lib-skill:web-development--postgresql",
      "to": "domain:web-development",
      "kind": "lib_applies_to_domain",
      "attributes": {
        "weight": 1
      }
    },
    {
      "from": "lib-skill:web-development--postgresql",
      "to": "role:backend-engineer",
      "kind": "lib_involves_role",
      "attributes": {
        "weight": 1
      }
    },
    {
      "from": "lib-skill:web-development--postgresql",
      "to": "role:fullstack-engineer",
      "kind": "lib_involves_role",
      "attributes": {
        "weight": 0.7
      }
    },
    {
      "from": "lib-skill:web-development--postgresql",
      "to": "specialization:web-development",
      "kind": "lib_belongs_to_specialization",
      "attributes": {
        "weight": 1
      }
    }
  ],
  "incomingEdges": []
}