{"owner":"Eventual-Inc","repo":"sql","hasSkills":true,"totalSkillsCount":4,"totalTokensCount":1212,"categories":["mcp-config","marketplace","plugin-manifest","cursor-rule"],"hasMcp":true,"mcpConfig":{"mcpServers":{"sql":{"command":"npx","args":["-y","@modelcontextprotocol/server-sql"]}}},"found":[".cursor/mcp.json",".claude-plugin/marketplace.json",".claude-plugin/plugin.json",".cursorrules (postgresql.mdc)"],"skills":{".cursor/mcp.json":"# Model Context Protocol (MCP) Configuration\n\nPath: `.cursor/mcp.json`\n\n[View Raw Content on GitHub](https://raw.githubusercontent.com/Eventual-Inc/sql/HEAD/.cursor/mcp.json)",".claude-plugin/marketplace.json":"# Claude Plugin Marketplace Catalog\n\nPath: `.claude-plugin/marketplace.json`\n\n[View Raw Content on GitHub](https://raw.githubusercontent.com/Eventual-Inc/sql/HEAD/.claude-plugin/marketplace.json)",".claude-plugin/plugin.json":"# claude-plugin Plugin Manifest\n\nPath: `.claude-plugin/plugin.json`\n\n[View Raw Content on GitHub](https://raw.githubusercontent.com/Eventual-Inc/sql/HEAD/.claude-plugin/plugin.json)",".cursorrules (postgresql.mdc)":"---\ndescription: \"PostgreSQL production rules. Safe migrations, parameterized queries, TIMESTAMPTZ, proper indexing strategy.\"\nglobs: **/*.sql, **/migrations/**/*.sql, **/schema.sql, **/seed.sql\nalwaysApply: false\n---\n# PostgreSQL Rules\n\nExpert PostgreSQL developer. Safe migrations, parameterized queries, proper indexing.\n\n## Schema\n- TIMESTAMPTZ for all timestamps (not TIMESTAMP without timezone)\n- UUID for public IDs, BIGSERIAL for internal keys\n- NOT NULL by default — nullable only when intentional\n- FK with explicit ON DELETE behavior\n- Check constraints for domain invariants\n\n## Queries\n- Parameterized always — never string interpolation\n- SELECT explicit columns, never SELECT *\n- LIMIT on all potentially large result sets\n- EXPLAIN ANALYZE before shipping complex queries\n\n## Indexes\n- Index every FK column\n- CREATE INDEX CONCURRENTLY for live tables (non-blocking)\n- Partial indexes for frequently filtered subsets\n- Remove unused indexes\n\n## Migrations\n- Versioned files: V001__create_table.sql\n- Large column additions: multi-step with backfill\n- Test rollback before deploying\n\n## Transactions\n- Explicit BEGIN/COMMIT for multi-statement changes\n- statement_timeout to prevent runaway queries\n- SELECT ... FOR UPDATE for row locking\n\n## Forbidden\n- No SELECT *\n- No string-interpolated SQL\n- No schema changes during peak traffic\n- No plaintext passwords in DB\n- No TRUNCATE in app code\n"},"files":{".cursor/mcp.json":"# Model Context Protocol (MCP) Configuration\n\nPath: `.cursor/mcp.json`\n\n[View Raw Content on GitHub](https://raw.githubusercontent.com/Eventual-Inc/sql/HEAD/.cursor/mcp.json)",".claude-plugin/marketplace.json":"# Claude Plugin Marketplace Catalog\n\nPath: `.claude-plugin/marketplace.json`\n\n[View Raw Content on GitHub](https://raw.githubusercontent.com/Eventual-Inc/sql/HEAD/.claude-plugin/marketplace.json)",".claude-plugin/plugin.json":"# claude-plugin Plugin Manifest\n\nPath: `.claude-plugin/plugin.json`\n\n[View Raw Content on GitHub](https://raw.githubusercontent.com/Eventual-Inc/sql/HEAD/.claude-plugin/plugin.json)",".cursorrules (postgresql.mdc)":"---\ndescription: \"PostgreSQL production rules. Safe migrations, parameterized queries, TIMESTAMPTZ, proper indexing strategy.\"\nglobs: **/*.sql, **/migrations/**/*.sql, **/schema.sql, **/seed.sql\nalwaysApply: false\n---\n# PostgreSQL Rules\n\nExpert PostgreSQL developer. Safe migrations, parameterized queries, proper indexing.\n\n## Schema\n- TIMESTAMPTZ for all timestamps (not TIMESTAMP without timezone)\n- UUID for public IDs, BIGSERIAL for internal keys\n- NOT NULL by default — nullable only when intentional\n- FK with explicit ON DELETE behavior\n- Check constraints for domain invariants\n\n## Queries\n- Parameterized always — never string interpolation\n- SELECT explicit columns, never SELECT *\n- LIMIT on all potentially large result sets\n- EXPLAIN ANALYZE before shipping complex queries\n\n## Indexes\n- Index every FK column\n- CREATE INDEX CONCURRENTLY for live tables (non-blocking)\n- Partial indexes for frequently filtered subsets\n- Remove unused indexes\n\n## Migrations\n- Versioned files: V001__create_table.sql\n- Large column additions: multi-step with backfill\n- Test rollback before deploying\n\n## Transactions\n- Explicit BEGIN/COMMIT for multi-statement changes\n- statement_timeout to prevent runaway queries\n- SELECT ... FOR UPDATE for row locking\n\n## Forbidden\n- No SELECT *\n- No string-interpolated SQL\n- No schema changes during peak traffic\n- No plaintext passwords in DB\n- No TRUNCATE in app code\n"},"items":[{"name":"marketplace.json","path":".claude-plugin/marketplace.json","rawUrl":"https://raw.githubusercontent.com/Eventual-Inc/sql/HEAD/.claude-plugin/marketplace.json","title":"Claude Plugin Marketplace Catalog","category":"marketplace","format":"json","content":"# Claude Plugin Marketplace Catalog\n\nPath: `.claude-plugin/marketplace.json`\n\n[View Raw Content on GitHub](https://raw.githubusercontent.com/Eventual-Inc/sql/HEAD/.claude-plugin/marketplace.json)","tokens":300,"sizeBytes":195},{"name":"plugin.json","path":".claude-plugin/plugin.json","rawUrl":"https://raw.githubusercontent.com/Eventual-Inc/sql/HEAD/.claude-plugin/plugin.json","title":"claude-plugin Plugin Manifest","category":"plugin-manifest","format":"json","content":"# claude-plugin Plugin Manifest\n\nPath: `.claude-plugin/plugin.json`\n\n[View Raw Content on GitHub](https://raw.githubusercontent.com/Eventual-Inc/sql/HEAD/.claude-plugin/plugin.json)","tokens":300,"sizeBytes":181},{"name":"mcp.json","path":".cursor/mcp.json","rawUrl":"https://raw.githubusercontent.com/Eventual-Inc/sql/HEAD/.cursor/mcp.json","title":"Model Context Protocol (MCP) Configuration","category":"mcp-config","format":"json","content":"# Model Context Protocol (MCP) Configuration\n\nPath: `.cursor/mcp.json`\n\n[View Raw Content on GitHub](https://raw.githubusercontent.com/Eventual-Inc/sql/HEAD/.cursor/mcp.json)","tokens":300,"sizeBytes":174},{"name":".cursorrules","path":".cursorrules (postgresql.mdc)","rawUrl":"https://raw.githubusercontent.com/PatrickJS/awesome-cursorrules/main/rules/postgresql.mdc","title":"Awesome Cursorrules: postgresql","category":"cursor-rule","format":"markdown","content":"---\ndescription: \"PostgreSQL production rules. Safe migrations, parameterized queries, TIMESTAMPTZ, proper indexing strategy.\"\nglobs: **/*.sql, **/migrations/**/*.sql, **/schema.sql, **/seed.sql\nalwaysApply: false\n---\n# PostgreSQL Rules\n\nExpert PostgreSQL developer. Safe migrations, parameterized queries, proper indexing.\n\n## Schema\n- TIMESTAMPTZ for all timestamps (not TIMESTAMP without timezone)\n- UUID for public IDs, BIGSERIAL for internal keys\n- NOT NULL by default — nullable only when intentional\n- FK with explicit ON DELETE behavior\n- Check constraints for domain invariants\n\n## Queries\n- Parameterized always — never string interpolation\n- SELECT explicit columns, never SELECT *\n- LIMIT on all potentially large result sets\n- EXPLAIN ANALYZE before shipping complex queries\n\n## Indexes\n- Index every FK column\n- CREATE INDEX CONCURRENTLY for live tables (non-blocking)\n- Partial indexes for frequently filtered subsets\n- Remove unused indexes\n\n## Migrations\n- Versioned files: V001__create_table.sql\n- Large column additions: multi-step with backfill\n- Test rollback before deploying\n\n## Transactions\n- Explicit BEGIN/COMMIT for multi-statement changes\n- statement_timeout to prevent runaway queries\n- SELECT ... FOR UPDATE for row locking\n\n## Forbidden\n- No SELECT *\n- No string-interpolated SQL\n- No schema changes during peak traffic\n- No plaintext passwords in DB\n- No TRUNCATE in app code\n","tokens":312,"sizeBytes":1412}],"systemPromptSnippet":"<yakaai_skills repo=\"Eventual-Inc/sql\">\n<!-- File: .claude-plugin/marketplace.json (Tokens: ~300 | Category: marketplace) -->\n# Claude Plugin Marketplace Catalog\n\nPath: `.claude-plugin/marketplace.json`\n\n[View Raw Content on GitHub](https://raw.githubusercontent.com/Eventual-Inc/sql/HEAD/.claude-plugin/marketplace.json)\n\n<!-- File: .claude-plugin/plugin.json (Tokens: ~300 | Category: plugin-manifest) -->\n# claude-plugin Plugin Manifest\n\nPath: `.claude-plugin/plugin.json`\n\n[View Raw Content on GitHub](https://raw.githubusercontent.com/Eventual-Inc/sql/HEAD/.claude-plugin/plugin.json)\n\n<!-- File: .cursor/mcp.json (Tokens: ~300 | Category: mcp-config) -->\n# Model Context Protocol (MCP) Configuration\n\nPath: `.cursor/mcp.json`\n\n[View Raw Content on GitHub](https://raw.githubusercontent.com/Eventual-Inc/sql/HEAD/.cursor/mcp.json)\n\n<!-- File: .cursorrules (postgresql.mdc) (Tokens: ~312 | Category: cursor-rule) -->\n---\ndescription: \"PostgreSQL production rules. Safe migrations, parameterized queries, TIMESTAMPTZ, proper indexing strategy.\"\nglobs: **/*.sql, **/migrations/**/*.sql, **/schema.sql, **/seed.sql\nalwaysApply: false\n---\n# PostgreSQL Rules\n\nExpert PostgreSQL developer. Safe migrations, parameterized queries, proper indexing.\n\n## Schema\n- TIMESTAMPTZ for all timestamps (not TIMESTAMP without timezone)\n- UUID for public IDs, BIGSERIAL for internal keys\n- NOT NULL by default — nullable only when intentional\n- FK with explicit ON DELETE behavior\n- Check constraints for domain invariants\n\n## Queries\n- Parameterized always — never string interpolation\n- SELECT explicit columns, never SELECT *\n- LIMIT on all potentially large result sets\n- EXPLAIN ANALYZE before shipping complex queries\n\n## Indexes\n- Index every FK column\n- CREATE INDEX CONCURRENTLY for live tables (non-blocking)\n- Partial indexes for frequently filtered subsets\n- Remove unused indexes\n\n## Migrations\n- Versioned files: V001__create_table.sql\n- Large column additions: multi-step with backfill\n- Test rollback before deploying\n\n## Transactions\n- Explicit BEGIN/COMMIT for multi-statement changes\n- statement_timeout to prevent runaway queries\n- SELECT ... FOR UPDATE for row locking\n\n## Forbidden\n- No SELECT *\n- No string-interpolated SQL\n- No schema changes during peak traffic\n- No plaintext passwords in DB\n- No TRUNCATE in app code\n</yakaai_skills>"}