Advanced Excel techniques for data analysis including formulas, pivot tables, Power Query, and dashboard creation.
Open Source
Skills for self-hosted AI using Ollama, LM Studio, and open-source models like DeepSeek, Qwen, and Llama. Full privacy, zero API costs, unlimited usage.
1030 skills available
Run powerful AI models locally with complete control over your data. Open-source tools like Ollama and LM Studio make it easy to deploy models rivaling proprietary services — no cloud dependency, no API costs, no data leaving your machine. The open-source ecosystem in 2026 has reached parity with commercial offerings for many tasks.
Popular Models to Run Locally:
- DeepSeek V3.2 — 671B total / 37B active parameters, comparable to GPT-5, MIT license
- Qwen3 — 700M+ downloads, models from 0.6B to 235B, Apache 2.0 license
- Llama 4 Scout/Maverick — Multimodal, up to 10M token context
- Mistral / Codestral — Strong for coding tasks
- Gemma, Phi, NVIDIA Nemotron — Smaller models for consumer hardware
Local Deployment Tools:
- Ollama — CLI-first, 20% faster inference, lower memory usage, ideal for developers and production
- LM Studio — GUI-focused with built-in chat, model discovery, and easy downloads
- LocalAI — OpenAI-compatible API for drop-in replacement
- vLLM — High-throughput serving for production deployments
Key Strengths:
- Complete privacy with local execution — no data leaves your machine
- Zero ongoing costs after hardware setup
- Works fully offline without internet
- Mix and match models for different tasks
- Unlimited usage with no rate limits or subscriptions
- Fine-tune and customize models for your domain
Best For: Privacy-critical workflows, air-gapped environments, unlimited AI experimentation, custom model fine-tuning, and developers who want full ownership of their AI stack.
Featured Articles
View allMoltbot: The Self-Hosted AI Agent That Hit 100K Stars in a Month
Moltbot (formerly OpenClaw/Clawdbot) went from zero to 100K+ GitHub stars in weeks. Here's what it is, why …
BlogMoltbot: That Viral AI Assistant Might Be Reading All Your Messages
Moltbot has 100K+ GitHub stars and connects to your WhatsApp, email, and Slack. Security researchers found …
BlogAI Agents Explained: What They Are, How They Work, and Why Everyone's Building Them
Everything you need to know about AI agents: how they differ from chatbots, how they work, when to use them, …
Trending This Week
Navigate buying your first home with confidence. Step-by-step guidance through saving, searching, making offers, and closing—with all the …
Create viral LinkedIn posts with proven hooks, personal storytelling, and professional engagement strategies.
Analyze contracts for red flags, missing clauses, and potential issues. Plain-English explanations of legal terms.
Browse All Skills
Master Docker containerization. Dockerfiles, Compose, multi-stage builds, networking, volumes, and production deployment.
Master end-to-end testing with Playwright and Cypress. Build reliable test suites that catch bugs and enable fast deployment.
Master Git rebasing, cherry-picking, bisect, worktrees, and reflog. Maintain clean history and recover from any mistake.
Expert guidance on resolving Git merge conflicts. Analyze conflict types, apply resolution strategies, and validate solutions.
Comprehensive testing with Jest, Vitest, and Testing Library. Unit tests, integration tests, mocking, and TDD for JS/TS projects.
Build production React apps with Next.js App Router, server components, data fetching, routing, and performance optimization.
Browser automation with Playwright. Web scraping, testing, screenshots, PDF generation, and multi-browser automation scripts.
Create distributable Python packages with pyproject.toml, proper structure, and PyPI publishing workflows.
Implement comprehensive testing strategies with pytest, fixtures, mocking, and test-driven development for robust Python applications.
Upgrade React apps systematically. Migrate class components to hooks, adopt React 18 features, and modernize legacy patterns.
Master machine learning with scikit-learn. Classification, regression, clustering, preprocessing, model evaluation, and production …
System design specialist for modern tech stacks. Architecture diagrams, design patterns, tech stack decisions, and dependency analysis for …
Master SQL query optimization, indexing strategies, and EXPLAIN analysis. Dramatically improve database performance and eliminate slow …
Build full-stack apps with Supabase. PostgreSQL, authentication, storage, real-time subscriptions, and edge functions.
Identify and prevent common testing mistakes. Stop testing mock behavior, avoid production pollution, and write meaningful tests.
Master uv, the extremely fast Rust-based Python package installer. 10-100x faster than pip for modern Python project management.
Build Retrieval-Augmented Generation systems that ground LLM responses in external knowledge sources. Reduce hallucinations and enable …
Master Python asyncio, concurrent programming, and async/await patterns for high-performance applications.
Comprehensive research, analysis, and content extraction system. Multi-source parallel research with deep content analysis for thorough …
Master utility-first CSS with TailwindCSS. Responsive design, dark mode, custom themes, and component patterns for rapid UI development.
Expert ReactJS, NextJS, and TypeScript development with performance optimization, bundle analysis, and modern frontend best practices.
Build accessible UI components with shadcn/ui. Beautifully designed components built on Radix UI and styled with Tailwind CSS.
No skills found matching your criteria.
Can't find what you need?
Tell us what AI skill or prompt you're looking for and we'll create it for you.
Request a Skill