Skill UI

This skill provides comprehensive performance optimization and best practices for PostgreSQL, maintained by Supabase. It guides users on optimizing database performance, covering critical areas such as writing efficient SQL queries, designing robust schemas, implementing proper indexing, managing connection pooling, and enforcing Row-Level Security (RLS).

This comprehensive checklist guides the secure deployment and hardening of a Supabase project for production use. It covers critical security measures such as enforcing Row Level Security (RLS), separating client and service keys, optimizing connection pooling via Supavisor, setting up Point-in-Time Recovery (PITR) backups, and configuring network restrictions. Use this guide before launching or for conducting security audits to ensure maximum stability and security.

This skill provides a comprehensive guide to securing Supabase projects. It covers critical security measures, including proper separation of anonymous and service role keys, enforcing Row Level Security (RLS) on all tables, and hardening the API surface. Use this when setting up a new project, performing security audits, or implementing robust data access control policies.

A comprehensive guide to building functional and scalable Telegram bots. Covers bot architecture design, mastering the Telegram Bot API, optimizing user experience (UX), implementing monetization strategies (Freemium, Subscriptions), and deploying production-ready bots using webhooks. Learn to transform complex ideas into engaging, real-world automated assistants.

Utilizes structured critical reasoning to rigorously stress-test ideas, plans, and decisions. This skill allows you to play devil's advocate, conduct pre-mortems, execute red-teaming exercises, or audit underlying assumptions. It employs multiple advanced modes, including Socratic questioning, Hegelian dialectics, and Falsificationism, to identify blind spots, weaknesses, and unstated assumptions before commitment.

This tool rigorously validates API schemas against industry standards, including OpenAPI 3.0/3.1, JSON Schema, and GraphQL SDL. It performs structural analysis to detect incomplete schemas, inconsistent naming, undocumented endpoints, and critical breaking changes. Use it within your CI/CD pipeline to ensure API contracts are robust, compliant, and maintainable before release.

Configures robust CI/CD pipelines for Vercel projects using GitHub Actions. This guide automates the full deployment lifecycle, including generating preview environments on every pull request, performing reliable production builds upon merging to main, and implementing test gating to ensure code quality before release. Ideal for professional web development workflows.

This guide provides comprehensive methods for deploying, promoting, and managing Vercel applications in production environments. It covers advanced strategies like instant rollback, controlled rolling releases (canary deployments), multi-region function configuration, and integrating with headless CMS via deploy hooks. Use this when you require robust CI/CD practices, high availability, and predictable production traffic management.

Guides deploying Next.js apps to Vercel covering environment variable strategy, choosing edge vs serverless runtimes, build optimizations, preview workflows, and custom domain setup to secure production releases.

Configure Vercel's advanced role-based access control (RBAC) for enterprise environments. This guide covers setting up granular team roles, managing project-level access groups, integrating SAML SSO for secure authentication, and enabling detailed audit logging. Use this when implementing strict security protocols and enforcing the principle of least privilege across your team's deployments and resources.

This comprehensive guide catalogs common anti-patterns and mistakes when deploying applications on Vercel. It covers critical architectural areas such as secret management (preventing key exposure), optimizing serverless function performance (cold start, timeouts), adhering to Edge Runtime standards, and resolving configuration errors. Use this skill for code reviews, security audits, and onboarding new developers to ensure best deployment practices.

This guide provides comprehensive methods for load testing and capacity planning of Vercel serverless deployments. Learn how to use professional tools like k6 and autocannon to simulate realistic traffic spikes, measure latency (P95, P99), analyze cold start impact, and tune concurrency settings (Fluid Compute) to ensure optimal application performance and scalability under heavy load.