Database

This skill covers using Bankrun for rapid, isolated, and deterministic testing of Solana programs.

The Solana Token Program (SPL Token program) is the official on-chain program for creating, managing, and transferring fungible and non-fungible tokens on Solana.

This skill focuses on strategies and techniques to reduce transaction costs, increase transaction reliability, and improve user experience on Solana by optimizing transaction size, compute unit consumption, and priority fee application.

This skill guides you through the process of setting up and operating a Solana validator, enabling you to participate in network consensus, process transactions, and earn staking rewards.

This skill guides you through the strategic preparation and technical execution required for listing your token on decentralized (DEX) and centralized (CEX) exchanges. You'll learn how to architect smart contracts for compliance, secure initial liquidity, and manage the technical aspects of market entry to ensure a stable and successful launch.

This skill guides you in developing robust tools and systems for managing investor relations within decentralized projects. You will learn to leverage on-chain data for transparency, automate communication workflows, and build trust through verifiable reporting and secure engagement channels. The focus is on implementing technical solutions that foster strong, informed relationships with your project's token holders and stakeholders.

This skill guides you through the end-to-end process of managing an NFT project, from smart contract development and metadata preparation to deployment and post-mint lifecycle. You'll learn to navigate technical execution, infrastructure choices, and community engagement strategies to deliver a successful and secure NFT collection.

This skill guides you through designing and implementing intuitive onboarding experiences for Web3 applications. You'll learn how to bridge the gap between traditional UX and the unique challenges of blockchain, focusing on wallet integration, transaction clarity, and progressive decentralization to convert new users into active participants.

This skill guides you through the strategic design and technical execution of a successful token launch. You'll learn how to architect sustainable tokenomics, implement secure distribution mechanisms, and navigate the complex landscape of community building and regulatory compliance to ensure long-term project viability.

This skill teaches you how to design and implement growth strategies unique to the web3 ecosystem. You'll learn to leverage tokenomics, NFTs, and on-chain mechanics to acquire, activate, and retain users, fostering a vibrant and sustainable decentralized community.

This skill covers the unique strategies and technical implementations required for marketing in the decentralized web3 ecosystem. You'll learn how to leverage on-chain data, smart contracts, and community-centric approaches to build, engage, and grow a project's user base in a transparent and permissionless environment.

This skill equips you to architect and implement strategic web3 partnerships, leveraging blockchain technology for transparent, trustless, and programmable collaborations. You'll learn how to establish on-chain agreements, manage shared resources securely, and integrate partner protocols to unlock synergistic value within decentralized ecosystems.

This skill covers the unique strategies and technical insights required to lead product development in the web3 space. You'll learn how to navigate decentralized ecosystems, design sustainable tokenomics, engage with community-driven governance, and understand on-chain data to build successful dApps and protocols.

This skill guides you in understanding the unique behaviors and needs of decentralized users in Web3. You'll learn how to ethically gather insights from on-chain data and community feedback, translating them into actionable product improvements for dApps and protocols.

This skill covers the extraction, transformation, and loading (ETL) of blockchain data into structured databases or data warehouses. You use this when building scalable analytics platforms, dApps requiring extensive historical data, or custom indexing services that go beyond simple RPC queries, enabling complex analysis and reporting.

This skill enables you to leverage DefiLlama's comprehensive aggregated data for decentralized finance protocols. You utilize this when building applications that require insights into Total Value Locked (TVL), historical protocol performance, yield opportunities, and cross-chain liquidity metrics, providing a standardized view of the DeFi landscape.

This skill enables you to leverage Dune Analytics for querying, analyzing, and visualizing blockchain data using SQL. You use this when building dashboards, creating custom data insights, or integrating on-chain data into applications, transforming raw ledger information into actionable intelligence.

This skill enables you to query, analyze, and visualize vast amounts of blockchain data using SQL. You leverage Flipside Crypto when you need deep, structured insights into on-chain activity, smart contract interactions, or token movements across multiple networks, without the complexity of direct RPC node parsing.

This skill teaches you to analyze, predict, and optimize transaction fees (gas) on EVM-compatible blockchains. You leverage gas analytics to minimize operational costs, improve user experience by ensuring timely transaction finality, and make informed decisions about dApp deployment and interaction strategies, especially during network congestion.

This skill empowers you to leverage Nansen Analytics' proprietary on-chain data and entity labeling for enhanced insights into blockchain activity. You employ Nansen when your applications demand deep, real-time intelligence on market movements, smart money flows, and whale activity, going beyond raw RPC data.

This skill equips you to extract, interpret, and analyze data directly from blockchain ledgers. You use this when building applications that require real-time insights into smart contract state, transaction history, or token movements, providing verifiable and immutable data sources.

This skill enables you to analyze on-chain wallet activity to build comprehensive user profiles. You leverage this when segmenting users, assessing risk, detecting fraud, or personalizing dApp experiences based on a wallet's transaction history, token holdings, and contract interactions.

Dark mode support patterns for email templates across major email clients

Accessible email design patterns for inclusive, standards-compliant email templates

Email deliverability essentials including SPF, DKIM, DMARC, and inbox placement

Email testing workflows using Litmus, Email on Acid, Mailtrap, and other QA tools

Building responsive email templates with the MJML markup language and toolchain

Building email templates with React Email components and rendering pipeline

Responsive email CSS patterns for consistent rendering across clients and devices

Designing and implementing transactional email templates for automated notifications

MVVM and Clean Architecture patterns for structuring scalable, testable iOS applications

Combine framework reactive programming patterns for handling asynchronous events in iOS

Core Data persistence framework for modeling, storing, and querying structured data in iOS apps

SwiftUI navigation patterns using NavigationStack, programmatic routing, and deep linking

URLSession networking patterns for building robust API clients and handling data transfer in iOS

Swift structured concurrency with async/await, actors, and task groups for safe concurrent iOS code

SwiftUI declarative UI framework fundamentals for building modern iOS interfaces

XCTest unit testing, UI testing, and test architecture patterns for reliable iOS applications

MVVM architecture pattern with ViewModel, LiveData, and StateFlow for scalable Android apps

Kotlin coroutines and Flow for asynchronous programming and reactive streams in Android

Hilt and Dagger dependency injection for managing object creation and scoping in Android apps

Jetpack Compose declarative UI toolkit for building native Android interfaces with Kotlin

Jetpack Navigation component for type-safe in-app navigation and deep linking in Android

Retrofit HTTP client for type-safe REST API communication in Android with Kotlin coroutines

Room persistence library for local SQLite database access with compile-time query verification in Android

Android testing with JUnit5 for unit tests and Espresso/Compose testing for UI verification

High-performance animations in React Native using Reanimated and Gesture Handler

Deploying React Native apps with EAS Build, app store submission, and OTA updates via EAS Update

Expo managed workflow for rapid React Native development with minimal native configuration

Creating native modules and Turbo Modules to bridge platform-specific functionality into React Native

React Navigation patterns for stack, tab, drawer, and nested navigators in React Native

Offline storage strategies in React Native using AsyncStorage, MMKV, and WatermelonDB

State management in React Native using Zustand and Jotai for scalable, performant app state

Styling approaches in React Native including StyleSheet, NativeWind, and responsive design patterns

Implicit, explicit, and hero animation patterns for polished Flutter UIs

Hive, SharedPreferences, and Drift patterns for local data persistence in Flutter

GoRouter navigation patterns for declarative, deep-linkable Flutter routing

Dio HTTP client and API integration patterns for Flutter applications

Platform channels for bridging Flutter with native Android (Kotlin) and iOS (Swift) code

Riverpod and Bloc state management patterns for scalable Flutter applications