Skill UI

A comprehensive guide for developing and managing applications using Amazon Aurora DSQL, a serverless, PostgreSQL-compatible distributed SQL database. This skill covers core capabilities including direct query execution, robust schema management, safe data migration from MySQL, multi-tenant architectural patterns, IAM-based authentication, and detailed query plan explainability for performance tuning. Essential for developers handling complex database evolution.

Automate the execution of integration tests against a live ClickHouse database instance within a Continuous Integration (CI) pipeline using Docker containers. This setup eliminates the need for mocks, ensuring thorough schema validation and query reliability in environments mirroring production deployments. Ideal for robust CI/CD setup and schema enforcement.

This skill provides expert guidance on building and maintaining applications using Amazon Aurora DSQL, a serverless, PostgreSQL-compatible distributed SQL database. It covers critical areas including schema management, multi-tenant architecture, IAM authentication, and safe data migrations (e.g., MySQL to DSQL). Users can execute direct queries, analyze performance bottlenecks using query plan explainability, and adhere to industry best practices for robust, scalable database design.

This skill provides comprehensive guidance for building and managing applications using Amazon Aurora DSQL, a serverless, distributed, PostgreSQL-compatible SQL database. Topics cover schema management, multi-tenant isolation, IAM authentication, complex DDL migrations (column, constraint), MySQL data type mapping, and advanced query performance tuning using plan explainability tools, ensuring robust and scalable data architecture.

This skill guides users through setting up robust, production-grade infrastructure on Fly.io. It covers creating and connecting to Fly Postgres clusters for reliable data storage, provisioning persistent NVMe Volumes for durable file storage, and configuring private internal networking (6PN) for secure service-to-service communication. It is essential for modern microservices requiring stable databases and persistent state.

This guide provides comprehensive strategies to significantly boost the performance and reliability of applications deployed on Fly.io. Techniques covered include eliminating cold starts (auto-stop/start), right-sizing Virtual Machines based on workload demands, implementing multi-region deployment for low latency, and optimizing connection pooling for databases. Essential for scaling modern SaaS applications.

This comprehensive guide provides step-by-step instructions for migrating and upgrading services on the Fly.io platform. It details critical processes such as migrating applications from Apps v1 (Nomad) to v2 (Machines), upgrading the flyctl CLI, performing major Postgres database version upgrades, and executing region migrations. Essential for maintaining and modernizing cloud infrastructure.

This plugin allows developers to build Framer components by syncing data from external data sources (such as APIs or databases) into Framer's Managed Collections. It serves as the primary integration pattern, handling both schema creation and item population. Use this when your design requires displaying dynamic content driven by external systems.

Provides advanced debugging techniques for Notion API issues that standard troubleshooting cannot resolve. It covers response ID inspection, tracing complex permission chains, detecting property type mismatches, managing pagination edge cases, and resolving block nesting limits across Notion databases and pages. Essential for robust integration development.

A comprehensive guide detailing five validated architecture patterns for utilizing Notion as a powerful backend database. Use cases include: Headless CMS for blogging, task tracking for project management, building knowledge bases (wikis), handling form submissions, and serving as a data pipeline source. Includes schema design and code examples using TypeScript and Python.

Provides comprehensive programmatic access to Notion, allowing users to create, update, archive, and compose rich content blocks within pages and databases. This skill covers the full page lifecycle—from initial creation with structured properties to appending complex blocks (headings, lists, toggles, code) and managing status updates. It is essential for building automated knowledge bases, automating content workflows, and programmatically managing enterprise information systems using the Notion API.

This guide provides three fundamental examples for integrating with the Notion API. It demonstrates how to search for existing pages, create new content within a database, and retrieve the newly created page's metadata. Ideal for developers starting a new Notion integration or implementing basic automated workflows.