Linear

Linear is a modern project management and issue tracking platform designed for software development teams to streamline their workflows, track bugs, manage feature requests, and coordinate product development efforts. It provides a fast, elegant interface for managing product issues, sprint planning, roadmapping, and team collaboration.

Category	IT service management
Direction	Query source
Sign-in	API Token
Query languages	SQLite
Tables	10
Query templates	59
Website	linear.app

Before you start

Huntbase signs in to Linear with API Token. Create the credential in Linear first, then keep it to hand for the Connect step.

1. In Linear, go to Settings › Account › Security & Access and create a personal API key.
2. Restrict the key to the Read permission instead of full access. Optionally, limit it to specific teams.
3. Copy the key.

Permissions:

• Read

Watch out for

• Members can create API keys only if an admin allows it under Settings › Administration › API › Member API keys.
• The key never has more access than the user who created it. If that user's permissions change, the key's access changes too.

For the vendor's own instructions, see Linear API documentation.

tip

Use a dedicated, read-only credential for Huntbase where the product allows it. Huntbase only needs to read.

Connect Linear

1. Go to Connections and click New connection, or click New connection on the Linear product page.
2. On Product, pick Linear and choose the Owner.
3. On Details, give the connection a Name and, optionally, a Description.
4. On Connect, fill in the settings and credentials described below.
5. On Verify, review the summary and click Create & check.

For everything else on the setup page — saving a draft, I'll do this later, and what each check result means — see Connections.

Settings

Where your Linear lives:

Field	Required	Notes
Page Size	No

Credentials

The only Method is API Token. Enter a Credential label (for example Production), then fill in:

Field	Required	Notes
API Token	Yes	Secret — not shown again after you save it.

Query it

Once connected, Linear can serve these languages in a query tab, and Scout can use it when you ask in Auto:

Language	Use it for
SQLite	SQL over the 10 tables listed below, alongside every other connected source.

Example: SQLite

Linear Integration Basic Info — Retrieve basic information about Linear integrations, including service name and creation and update timestamps.

select
  id,
  created_at,
  service,
  updated_at
from
  linear_integration;

Linear ships with 59 query templates. Find them in Library › Queries — see Query templates.

Tables

Linear adds 10 tables. Browse their columns from Schema in the query bar's ⋯ menu.

All 10 tables

Table	Contains
linear_attachment	Linear Attachment
linear_comment	Linear Comment
linear_integration	Linear Integration
linear_issue	Linear Issue
linear_issue_label	Linear Issue Label
linear_organization	Linear Organization
linear_project	Linear Project
linear_team	Linear Team
linear_team_membership	Linear Team Membership
linear_user	Linear User

Next steps

• Connections — health, credentials and settings after you connect
• Query languages — syntax, parameters and time ranges
• Chatting with Scout — ask questions without writing a query
• All integrations — the rest of the catalog