A workspace for planning, drafting, and scheduling LinkedIn posts. Capture ideas, write drafts, plan them on a calendar, and see how you write, measured from your own past posts.
No AI, no API keys, no accounts. Your data stays in your own database.
| Page | What it does |
|---|---|
| Dashboard | What's ready or scheduled, what you're working on, your open ideas, and a snapshot of your writing stats. |
| Ideas 💡 | Idea bank with status, category, priority, hook, tags, links, notes, and a planned date. Turn any idea into a draft in one click. |
| Drafts | Editor with a 3,000 character counter, status, category, and post date. Shows your word count against your usual length, and warns when a draft looks like something you've already posted. |
| Calendar | Month view of ideas, drafts, ready and published posts. Drag to schedule. Shows posting themes for the month and nudges you when one topic dominates. |
| My Voice | Measured from your writing samples: words per post and per sentence, paragraph length, emoji, em dash and hashtag use, how often you end with a question, your most used words and openings. Compares your ❤️ posts with the rest. |
| Writing Samples | Add past posts one at a time or paste many at once. Rate each one ❤️ exactly like me / 👍 like / 👎 not me. |
LinkedIn Copilot provides a simple workspace to manage your LinkedIn content from idea generation to scheduling and writing style analysis.
Get an overview of your content workflow, including ideas, drafts, scheduled posts, and writing statistics.
Capture and organize post ideas with categories, priorities, tags, notes, and planned dates.
Write and manage LinkedIn posts with a character counter, word count, and draft status.
View your content schedule, manage planned posts, and organize your publishing calendar.
Understand your writing style through statistics about your writing samples, sentence length, word usage, emojis, and more.
Add previous LinkedIn posts and rate how closely they represent your writing style.
Press i anywhere to capture a quick idea.
- Next.js 15 (App Router) + React 19 + TypeScript
- Tailwind CSS
- Postgres (Neon / Netlify DB) on serverless hosts, or a local SQLite file via Node's built-in
node:sqlite
Requires Node 22.13+.
npm install
npm run devOpen http://localhost:3000. Data is saved to ./data/copilot.db; no setup needed.
| Variable | Required | Notes |
|---|---|---|
DATABASE_URL |
on serverless hosts | Postgres connection string (Neon or Netlify DB). When set, it's used instead of SQLite. NETLIFY_DATABASE_URL is picked up automatically. |
DATABASE_PATH |
no | SQLite file location when no DATABASE_URL is set. Defaults to ./data/copilot.db |
Netlify (or Vercel): serverless functions can't keep a local file, so use Postgres.
- Add a database. On Netlify, enable Netlify DB (it sets
NETLIFY_DATABASE_URLfor you). Anywhere else, create a free Neon database and setDATABASE_URL. - Deploy. Tables are created automatically on first request.
A server with a disk (Railway, Render, Fly.io, a VPS): no database setup needed. Point DATABASE_PATH at a persistent volume.
There is no login. Anyone who can reach your deployment can read and edit its data. Keep the URL private or put it behind your host's access controls.
src/
app/
(workspace)/ pages: dashboard, ideas, drafts, calendar, voice, samples
api/ route handlers (samples, ideas, drafts)
components/ client UI
lib/
memory.ts repeat detection + writing stats
store.ts data access
db.ts Postgres / SQLite drivers + schema
Contributions are welcome! See CONTRIBUTING.md to get started, and please follow the Code of Conduct. To report a security issue, see SECURITY.md.
MIT. See LICENSE.
This is an independent project. It is not affiliated with, endorsed by, or sponsored by LinkedIn Corporation. "LinkedIn" is a trademark of LinkedIn Corporation. The app does not connect to LinkedIn or use its API.





